Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
felcar2013
Partner - Creator III
Partner - Creator III

indirect field selection in expression

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand
sorrakis01
Specialist
Specialist

Hi,

Check this

Regards

felcar2013
Partner - Creator III
Partner - Creator III
Author

Thanks