Set Analysis is not Working Propperly

[mhmmd_srf]

Hi All,

I have a Date Filter and I want to make my set expression like this.

If we select Year = 2017, Month = March then we will have dates will be 1st March to 10 march.

If i select any date it will show value for till that date.

My expression is below:

Count({<DT={'=<$(v2)'}>}OrderLineDueCount).

But this is not working.

I am attaching my qvw file.

Could you please check and help to resolve.

Thanks,

Sarif

[Anil_Babu_Samineni]

65 MG is file size.. WOW

Count({<DT = {'$( '<=' & =Max(DT))'}, Year = {'$(=Max(Year))'}>} OrderLineDueCount)

Or

Count({<DT = {"<= $(=Max(DT))"}, Year = {'$(=Max(Year))'}>} OrderLineDueCount)

[MK_QSL]

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

[sunny_talwar · Accepted solution]

Try this

=Count({<DT={'<=$(=$(v2))'}>}OrderLineDueCount)