MonthYear Filter issues in Set analysis

[123qlik123]

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,

mr

[ogautier62]

Hi,

I got the same error ina text box,

and it works with :

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

regards

[pooja_prabhu_n]

Try with quotes

MonthYear={'$(=vMonthYear)'}

[123qlik123]

Hi Nagaraj,

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

Regards,

MR

[123qlik123]

Hi Gautier,

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

Regards,

MR

[sunny_talwar · Accepted solution]

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, ','), '*')

[123qlik123]

Hi Sunny,

Thanks for the reply,

Still it's not working, issue remains same.

Regards,

MR

[sunny_talwar]

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

[123qlik123]

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

Regards,

MR