topic Conditional Show Expression in QlikView

Conditional Show Expression

hopkinsc — Mon, 18 Oct 2010 10:05:46 GMT

I am using a drill down group with 5 drill downs.

Dept Name

Cat Name

SubCat Name

Product

Customer

I have added another dimension 'EAN', I only want to show the EAN column when the user has drilled down to PRODUCT.

Does anyone know what expression i should write for this?

Conditional Show Expression

Mon, 18 Oct 2010 10:48:59 GMT

Are you using Bar chart or straight table?

In straight table there is an option to show/hide the columns. There you can give the condition "getcurrentfield(group)=PRODUCT" to show/hide your second dimension.

Conditional Show Expression

hopkinsc — Mon, 18 Oct 2010 10:58:46 GMT

Hi Shans_bala,

Thanks for your reply, i am using a straight table. I have tried your expression, I am guessing that the GROUP part should be the name of my drill down group?

so i have tried... getcurrentfield(DeptToCustomer)=Product

but it doesn't work....

Conditional Show Expression

Mon, 18 Oct 2010 11:04:49 GMT

I think it's getCurrentField(DeptToCustomer) = 'Product' beetween quotes (because GetCurrentField returns a string containing the field name).

You can check adding an expression containing just "getCurrentField(DeptToCustomer)" (without quotes, obviously).

Bye

Conditional Show Expression

hopkinsc — Mon, 18 Oct 2010 11:08:40 GMT

Thanks very much, that worked....