topic Re: Exclude filter for Month Bar chart when selecting on the month filter in QlikView

Exclude filter for Month Bar chart when selecting on the month filter

qliknexus_kgcru — Wed, 11 Jul 2018 09:33:45 GMT

Hi All,

I need to have a tabular chart which shows sum(measure) per YTD and Months:

I have initially created this chart using Pick function. For the Dimension: =Pick(Dim,'YTD', FISC_MONTH)

Dim is a island table which contains values 1,2,3. FISC_MONTH is the fiscal months dimension which contains values APR, MAY, JUNE etc

For the expression I've used this, Pick(Dim, SUM({<FISC_MONTH= >}TOTAL measure),SUM({<FISC_MONTH= >}measure))

My issue now is that I have a Year and a Month filter. Month filter containing the FISC_MONTH values. The chart needs to be filtered by the Year only, and the month filter will not affect the chart upon selection.

On my expression, the YTD value on the chart is not affected as expected but the Months are affected (which should not) when selecting a month in the month filter. Is there any solution or work around on this?

Thanks!

Re: Exclude filter for Month Bar chart when selecting on the month filter

Gysbert_Wassenaar — Wed, 11 Jul 2018 10:46:01 GMT

Override the selection in your month field too:

Pick(Dim, SUM({<FISC_MONTH= >}TOTAL measure),SUM({<MyMonthField=,FISC_MONTH= >}measure))

Re: Exclude filter for Month Bar chart when selecting on the month filter

sunny_talwar — Wed, 11 Jul 2018 11:03:54 GMT

May be you need this

Pick(Only({1} Dim), Sum({<FISC_MONTH>}TOTAL measure), Sum({<FISC_MONTH>}measure))

Re: Exclude filter for Month Bar chart when selecting on the month filter

qliknexus_kgcru — Wed, 11 Jul 2018 12:33:51 GMT

‌Hi Gysbert,

i only have one month field which is the FISC_MONTH, which i have already included in the expression. What MyMonthField are you pertaining to? Thanks!

Re: Exclude filter for Month Bar chart when selecting on the month filter

qliknexus_kgcru — Fri, 13 Jul 2018 00:51:14 GMT

tried this also but it didn't work. could it be that it's not working because i'm using FISC_MONTH as the dimension and set identifier?

Re: Exclude filter for Month Bar chart when selecting on the month filter

sunny_talwar — Fri, 13 Jul 2018 11:18:25 GMT

could it be that it's not working because i'm using FISC_MONTH as the dimension and set identifier?

I don't think this is a problem...would you be able to share a sample to show the issue?