Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Using Values in Expression

Hello everyone:

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

expression.

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.  

4 Replies
Not applicable

Re: Using Values in Expression

Store the expression in variable and use it insted of reading the label text.

Not applicable

Re: Using Values in Expression

Hi,

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.

Regards,

Ricardo

Not applicable

Re: Using Values in Expression

Hello Mr. Baeyens:

Thanks for your reply and time, I tried using the variable but have an

issue,

the value passed out of the variable expression is lumped out like sample

below.

(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.

Not applicable

Re: Using Values in Expression

Hi Ricardo:

Thanks for your reply, but need to use a pivot table

Thanks

Kumar

Community Browser