topic Re: Set Analysis is not Working Propperly in QlikView

Set Analysis is not Working Propperly

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 06 Apr 2017 09:49:40 GMT

65 MG is file size.. WOW

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

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

MK_QSL — Thu, 06 Apr 2017 09:51:21 GMT

sunny_talwar — Thu, 06 Apr 2017 09:52:45 GMT

Try this

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