topic Set Analysis in QlikView

Set Analysis

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

=count(if([Expiration Date Abbrev MDY] > today(),

if([Expiration Date Abbrev MDY] < AddMonths(today(),2),[ID])))

trying to put the above in set analysis as below but its not working...

=count({<

[Expiration Date Abbrev MDY] = {"> Today()"},

[Expiration Date Abbrev MDY]= {"< AddMonths(Today(),2)"}>}ID)

What am I doing worng ?also my [Expiration Date Abbrev MDY] is in MM/DD/YY format.

Thanks much.

sunny_talwar — Tue, 18 Oct 2016 17:24:27 GMT

Try this Ansh

=Count({<[Expiration Date Abbrev MDY] = {"$(='>' & Date(Today(), 'MM/DD/YY') & '<' & Date(AddMonths(Today(), 2), 'MM/DD/YY'))"}>} ID)

Anonymous — Tue, 18 Oct 2016 17:26:00 GMT

Try this:

count({<

[Expiration Date Abbrev MDY] = {"<$(=Date(AddMonths(Today(),2), 'MM/DD/YY'))",">$(=Date(Today(), 'MM/DD/YY'))"} >} ID)

Frank_Hartmann — Tue, 18 Oct 2016 17:35:05 GMT

try this:

count({<[Expiration Date Abbrev MDY] = {">$(=Date(Today(),'MM/DD/YY'))<$(=Addmonth(Today(),2),'MM/DD/YY'))"}>} ID)

hope this helps

apthansh — Tue, 18 Oct 2016 19:24:41 GMT

Thanks much.That worked.