Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
=Count({< SALE_DATE_NEW = {">$(vMinDateNew)<$(vMaxDateNew)"}>} SALE_UNIQUEID)
Hi,
Try this way
=Count({<SALE_DATE_NEW= {"<=$(vMaxDateNew)>=$(vMinDateNew)"}>}SALE_UNIQUEID)
Regards,
Kaushik Solanki
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.