topic Set analysis in QlikView

Set analysis

Tue, 07 May 2013 12:10:11 GMT

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

Re: Set analysis

swuehl — Tue, 07 May 2013 12:17:17 GMT

Try

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

Re: Set analysis

kaushiknsolanki — Tue, 07 May 2013 12:17:22 GMT

Hi,

Try this way

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

Regards,

Kaushik Solanki

Re: Set analysis

Tue, 07 May 2013 12:29:56 GMT

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.