Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to represent the following statement as a single number in a dashboard and not as a table:
if (count ({<Delivered -= {'0'}>}distinct Account)='0', count(Account), 0)
I've been able to do this previously with a normal 'count' statement by creating a Chart | Straight Table without any dimensions - this seems to total (sum) the results. The above statement just comes up with a blank.
Thanks for any help.
Hi,
Try this in Text Object instead of Straight table
=if (count ({<Delivered -= {'0'}>}distinct Account) = 0, count(Account), 0)
Regards,
Jagan.
Thanks Jagan - I didn't know the Text box could do that.
Appreciate your help - only problem is, it is returning a zero value. Any ideas? or would i need to upload my data?
Which version of Qlikview desktop your are using?
Hope the below expression could help
if (count ({$-<Delivered = {'0'}>}distinct Account)=0, count(Account), 0)
Hi,
Upload your qlikview file and expected output values.
Regards,
jagan.
Hi,
Can you try the expression
1. Without the modifier if (count ({$}distinct Account)=0, count(Account), 0)
2. and if (count ({1}distinct Account)=0, count(Account), 0)
3. Then add a modifer if (count ({$ <Delivered = >}distinct Account)=0, count(Account), 0). and so on...
This could help to identify why you are getting 0
Regards,