Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

i have listbox like year,quarter,month and some chart but when i clik on month it has to display only the result of month refelection should not happened in other list box like year,quarter?

i have listbox like year,quarter,month and some chart but when i clik on month it has to display only the result of month refelection should not happened in other list box like year,quarter?

3 Replies
its_anandrjs

Use SET analysis in the chart like

Sum({<year=,quarter=>} Sales)

when you use this no reflection in another list box of year and quarter.

rajat2392
Partner - Creator III
Partner - Creator III

if you are not making any selection in other filters, then there will be no change on the result. But if have made any selection, then will affect. You can add set modifier in the expression and nullify all other selections.

if you want to show for the selected month only, so for rest of all the filters, do the nullification as below

sum({<Year=, Quarter=>} Sales)

and if you have hard-coded for a particular month, and want to have no change with any selection in any filter, then write this expression

sum({ 1 <Month={'Jan'}>} Sales)

MK_QSL
MVP
MVP

You need to use Alternate State with Year is State1 and Quarter/Month in State2.