Set analysis

[#1]

Hey,

I have the following formula which works like a charm:

=Count({<SALE_DATE_NEW={"$(vMaxDateNew)"}>}SALE_UNIQUEID)

However, I can't get Qlikview to count the sales before the MaxDate. I need this because I want to evaluate sales in a range between vMaxDateNew and vMinDateNew.

Somewhat like:

=Count({<{"$(vMinDateNew)<SALE_DATE_NEW<{"$(vMaxDateNew)"}>}SALE_UNIQUEID)

Please help, all the single and double quotes are starting to confuse me!

Kr,

Daniël

[swuehl]

Try

=Count({< SALE_DATE_NEW = {">$(vMinDateNew)<$(vMaxDateNew)"}>} SALE_UNIQUEID)

[kaushiknsolanki]

Hi,

    Try this way

     =Count({<SALE_DATE_NEW= {"<=$(vMaxDateNew)>=$(vMinDateNew)"}>}SALE_UNIQUEID)

Regards,

Kaushik Solanki

[#4]

Hey,

I tried your solutions, but they didn't work. (I tried similar options myself). Anyway, I now set the dates to integers (previously 'MM/DD/YYYY' and somehow that solved the issue.

Many thanks for your responses.