Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

poojask123
New Contributor II

QlikSense - Filter selection affecting charts

Hi,

Is it possible to restrict selection made on a particular value in a list box to not affect a chart ?

for example,

I have a list box with MonthNames.

and I have a bar chart which displays Revenue by Months. This chart should omit the Months June and July in the x-axis.

When i select the Months - June or July on the filter, the chart should remain unaffected by the selection, while for any other selection apart from these 2 months, the chart should display the corresponding data.

i wrote an expression like -

sum({<Year={2012,2013,2014},if( Wildmatch(Month,'Ju*'),Month=) >}  Sales)

Doesn't seem to be working..it does skip June and July from the chart, but when i select these months in the filter, i get a "no data to display message"

Can someone please help here?

Thanks

Pooja

1 Solution

Accepted Solutions
devarasu07
Honored Contributor II

Re: QlikSense - Filter selection affecting charts

Hi,

PFA, Tks

sum({$<Year={'2012','2013','2014'},Month={'*'} - {'Jul','Jun'}>} Revenue)

also you use

sum({$<Year={'2012','2013','2014'},Month -={'Jul','Jun'}>} Revenue)

Capture.JPG

3 Replies
devarasu07
Honored Contributor II

Re: QlikSense - Filter selection affecting charts

Hi Pooja,

you can try like below,

sum({$<Year={'2012','2013','2014'},Month={'*'} - {'Jul','Jun'}>} Revenue)

devarasu07
Honored Contributor II

Re: QlikSense - Filter selection affecting charts

Hi,

PFA, Tks

sum({$<Year={'2012','2013','2014'},Month={'*'} - {'Jul','Jun'}>} Revenue)

also you use

sum({$<Year={'2012','2013','2014'},Month -={'Jul','Jun'}>} Revenue)

Capture.JPG

poojask123
New Contributor II

Re: QlikSense - Filter selection affecting charts

Hi Devarasu,

Thank you for the answer. It worked

i had to use wildcard so my final expression looks like

sum({$<Year={'2012','2013','2014'},Month={'*'} - {'Ju*'}>} Revenue)