topic Re: Dynamically Add Expressions in QlikView

Dynamically Add Expressions

jasonwills — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

After a bit of guidance really, and a push in the right direction.

if i have a set of data such as:

Total Sales for ProductA by Year and Total Sales for ProductB by Year

is there a way that i can ask the user to choose from a list of products ( A, B etc.)?

Based upon their choice (multi select) the year would be the dimension along the bottom, and the chosen products would then appear on the bar chart?

I have a feeling i may need to look at conditional expressions, but if anyone has some guidance, i'd welcome it.

Hopefully i have explained it enough, but please kick me if it makes no sense.

Many Thanks in advance,

Jason

sunny_talwar — Thu, 13 Oct 2016 16:40:43 GMT

This link has a logic for a straight table, but you should be able to port over the functionality to bar chart

jasonwills — Fri, 14 Oct 2016 07:53:45 GMT

Thanks Sunny T, a definite point in the right direction, should be able to work it out now.

Cheers

Jason