Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to write a expression like below but this is not giving me any output even there is not error in the expression
Can someone please correct me on this
Expression :
=if(Floor(DelDate)=Floor(ColectDate),
count({<Status={'Closed'},
Sales={'Ach'}>}ID))
Thanks in Advance
The If needs to be inside the Count(). You can write it using set expression like this:
count({<Status={'Closed'},Sales={'Ach'},ID={"=Floor(DelDate)=Floor(ColectDate)"}>}ID))
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
The If needs to be inside the Count(). You can write it using set expression like this:
count({<Status={'Closed'},Sales={'Ach'},ID={"=Floor(DelDate)=Floor(ColectDate)"}>}ID))
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
I tied the same expression you suggested but this is not working for me .I am using this set expression in a line chart
Thanks
1. In the expression editor, does it display "OK" a the bottom of the editor?
2. What output do you get?
-Rob