Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a measure created in expression called 'SalesAmount' using set analysis,
currently I am using this Label of SalesAmount in the formula of another
My problem is that when I disable the SalesAmount measure (so as to not to
show in the table) the formula where I am using the label of the SalesAmont
also gets disabled, is there any way around this.
Appreciate any help on this issue.
Store the expression in variable and use it insted of reading the label text.
If you use a straight table, you should go to properties -> "Presentation" sheet, select the expression (Columns) and check the "Hide Column" option.
Pivot table doesn't have the hide column option.
Hello Mr. Baeyens:
Thanks for your reply and time, I tried using the variable but have an
the value passed out of the variable expression is lumped out like sample
(The Part & Region Dimensions used in the Pivot table are dynamic)
Part Region Sales vSalesFrom Expr
A Canada $10 $30
B US $10 $30
C US $10 $30
Appreciate any help in the above.
Thanks for your reply, but need to use a pivot table