Is it possible to have Expression group selector?

[#1]

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.

[nagaiank]

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

[#3]

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

[jagan]

Hi Venkatramana,

Check this thread hope it helps you.

Adhoc reporting in Qlikview

Regards,

Jagan.

[#5]

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.