How to do it notes and tutorial from a QlikView Desktop user who uses QlikView for data analysis and helps clients and co-workers get the most out of their data. A mix of tips for both beginners and advanced users with a focus on things you won't find in the manual.
QlikView is one of the most useful data review and analysis tools available for people who make sense of data for a living.
Saturday, March 2, 2013
Referring to a Column Label When the Label is a Text Expression
Last week, I added an enhancement to a QlikView document that had been in use for over two years. My task was simply to add a column to a straight table that would have an expression like this: =[column1] - [column2]. It should be pretty simple. But the two columns I needed to refer to had text expressions using variables in their column labels. The two column labels looked like this: =abv_PRICE&' '&lbl_Cmpr&' '&abv_EUAVG =abv_COST&' '&lbl_Cmpr&' '&abv_EUSTD It took a few tries to get the syntax right. I didn't change the existing columns but I copy and pasted their label expressions into my column expression and then modified the syntax and added dollar sign expansion. The expression for my new column still refers to the two other columns using their column labels within square brackets; it looks like this: [$(='$(abv_PRICE) $(lbl_Cmpr) $(abv_EUAVG)')]-[$(='$(abv_COST) $(lbl_Cmpr) $(abv_EUSTD)')] I hope this might help someone with a similar problem to solve.
QlikviewNotes has moved!
-
My QlikviewNotes blog has relocated to the Qlikview Cookbook site. All
links to the qlikviewnotes.blogger.com site have been automatically
redirected to th...
Tim Benoit is a QlikView practitioner and supply chain consultant living and working in Connecticut.
You can view Tim's Linkedin profile here: www.linkedin.com/in/timbenoitct
1 comment:
Thanks, that was indeed helpful!
Post a Comment