Expression

[smilingjohn]

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 

[rwunderlich · Accepted solution]

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

[smilingjohn]

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

[rwunderlich]

1. In the expression editor, does it display "OK" a the bottom of the editor?

2. What output do you get?

-Rob