Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having trouble with Set Analysis syntax to come up with a total count of records.
(I am using a counter so the function is SUM instead of count)
I need to get the total count of records for all' Rented' units where the MoveOutDate is null. (sounds easier that it is).
I thought it was as simple as my statement below but it is not.
Sum({<UnitStatus={'Rented'},isnull(MoveOutDate)>}#MoveInCounter)
I have tried some other complex suggestions I found in this forum but so far nothing has worked for me.
Thanks in advance.
Miguel Gavidia
Hi.
Maybe not the faster way, but just to see if it works.
Sum(if(UnitStatus='Rented' and isnull(MoveOutDate),MoveInCounter))
Alessandro Furtado
Hi.
Maybe not the faster way, but just to see if it works.
Sum(if(UnitStatus='Rented' and isnull(MoveOutDate),MoveInCounter))
Alessandro Furtado
Alessandro, Your above solution resolved my problem; now I can move on to the next hurdle on my project. Thank you very much! Regards, Miguel Gavidia
An excellent write up on general processing of nulls can be found here
http://community.qlik.com/docs/DOC-3155
Recommended reading for all QV Developers
-Rob