topic Re: Using Values in Expression in QlikView

Using Values in Expression

Sun, 14 Apr 2013 01:05:04 GMT

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.

Sun, 14 Apr 2013 05:02:26 GMT

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

Sun, 14 Apr 2013 05:26:00 GMT

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

Sun, 14 Apr 2013 12:12:03 GMT

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.

Sun, 14 Apr 2013 12:13:51 GMT

Hi Ricardo:

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

Thanks

Kumar