topic Re: MonthYear Filter issues in Set analysis in QlikView

MonthYear Filter issues in Set analysis

123qlik123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I am using below expression in my set analysis, it's working if I select any of the report filters apart from the month year filter.

count({1<Year={$(=vYear)},Quarter={$(=vQuarter)},Month={$(=vMonth)},MonthYear={$(=vMonthYear)},Region={'$(=vRegionl)'},SubRegion={'$(=vSubRegion)'}, Country ={'$(=vCounty)'},ProductName={'$(=vPrdName)'},Segment={'$(=vSeg)'},>} TOTAL distinct AccountID)

One of the variable value given below and same ways has created the expression for other filters in set modifier as well.

vMonthYear = =if(GetSelectedCount(MonthYear)>0,concat(distinct MonthYear,','),'*')

Issue:

If I select the value MonthYear filter on selection the above expression shows on text box is "Error in Expression" ( please refer the below screen shot), but the same expression is working fine for other filter in the dashboard like Region, Year, Month ect...

Kindly suggest me on this issue.

Thanks in advance,

Best Regards,

Re: MonthYear Filter issues in Set analysis

ogautier62 — Wed, 18 Jul 2018 06:35:39 GMT

Hi,

I got the same error ina text box,

and it works with :

={<MonthYear = {"=$(vMonthYear)"} >} .......................)

regards

Re: MonthYear Filter issues in Set analysis

pooja_prabhu_n — Wed, 18 Jul 2018 06:36:52 GMT

Try with quotes

MonthYear={'$(=vMonthYear)'}

Re: MonthYear Filter issues in Set analysis

123qlik123 — Wed, 18 Jul 2018 08:30:33 GMT

Hi Nagaraj,

I tried with this option, it's showing null values.

Regards,

Re: MonthYear Filter issues in Set analysis

123qlik123 — Wed, 18 Jul 2018 08:39:19 GMT

Hi Gautier,

I tried with your option but the expression shows on text box is null. Thanks.!

Regards,

Re: MonthYear Filter issues in Set analysis

sunny_talwar — Wed, 18 Jul 2018 10:32:30 GMT

I think all you need is to try this

Count({1<Year = $::Year, Quarter = $::Quarter, Month = $::Month, MonthYear = $::MonthYear, Region = $::Region, SubRegion = $::SubRegion, Country = $::Country, ProductName = $::ProductName, Segment = $::Segment>} TOTAL DISTINCT AccountID)

Where $:: will take care of this requirement

=If(GetSelectedCount(MonthYear) > 0, Concat(DISTINCT MonthYear, ','), '*')

Re: MonthYear Filter issues in Set analysis

123qlik123 — Wed, 18 Jul 2018 11:46:25 GMT

Hi Sunny,

Thanks for the reply,

Still it's not working, issue remains same.

Regards,

Re: MonthYear Filter issues in Set analysis

sunny_talwar — Wed, 18 Jul 2018 15:45:45 GMT

Would you be able to share a sample showing the non-working of the above? I would be curious to see what might be wrong

Re: MonthYear Filter issues in Set analysis

123qlik123 — Thu, 19 Jul 2018 06:41:01 GMT

Sure Sunny, will share you the sample file. It's not an urgent issue as of now. Thnx.!

Regards,