topic Re: Is it possible to have Expression group selector? in QlikView

Is it possible to have Expression group selector?

Thu, 27 Mar 2014 01:15:15 GMT

Hi,

I am very new to Qlikview. I have a grid in which i have about 30 expressions, which i can device into 3 groups (lets say sales expressions and inventory expressions and others). Is there way i can create 3 groups and provide option to interactively change the group? for ex when user selects Sales group, grid should display 10 sales expressions, is there way to implement this without creating 3 separate grids each with different set of metrics.

Re: Is it possible to have Expression group selector?

nagaiank — Thu, 27 Mar 2014 01:26:35 GMT

You can have one grid with all expressions, and use conditional display of the expressions based on the group selected.

Re: Is it possible to have Expression group selector?

Thu, 27 Mar 2014 01:48:02 GMT

yes Venkatramana. There are many ways of implementing it. But one quick and basic method is have an inline table with the Expression name and the formula. And then use the DSE in your expressions to have a dynamic expression.

for the condition you can use the function Substringcount().

Thanks,

Ram

Re: Is it possible to have Expression group selector?

jagan — Thu, 27 Mar 2014 02:02:29 GMT

Hi Venkatramana,

Check this thread hope it helps you.

Adhoc reporting in Qlikview

Regards,

Jagan.

Re: Is it possible to have Expression group selector?

Thu, 27 Mar 2014 16:59:18 GMT

Hi Ram Kumar,

Sorry i not much familiar with Qlikview yet, I am still learning. can you be more specific on how to use DSE and Dynamic Expressions.