topic Re: indirect field selection in expression in QlikView

indirect field selection in expression

felcar2013 — Mon, 03 Aug 2015 09:41:47 GMT

hi,

i have the attached application. I want to do the following:

1. select a month in the month_text filter (say April 2015)

2. get the month_id selected (90)

3. get the selected month_id in the Expression of the bar Chart. Actually the bar Chart disappear, what i do not want.

For example:

i select April 2015 and get the bar at the value of 12 (red bar)

i select the corresponding month_id and i get both bars 5 (blue) 12 (red) ones, what is the expected result.

why if i have indirectly selected the month_id = 90, it has no effect on the Expression?

thanks for any help on this.

felipe

Gysbert_Wassenaar — Mon, 03 Aug 2015 09:48:25 GMT

You have to tell your expressions to ignore your selection in month_text:

count({$<month_text=,month_id={$(=max(month_id)-4)}>} distinct kunde_id)

See attached qvw.

sorrakis01 — Mon, 03 Aug 2015 09:50:10 GMT

Hi,

Check this

Regards

felcar2013 — Mon, 03 Aug 2015 10:26:15 GMT

Thanks