Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am using
=count({<Resource={'A','B' }>}ID) to get the count of ID which are having Resource A and B.
I have a list box Resource
If I make any selection on Resource filter my count is not changing .
Why ??
PS : dont use 'not equal ' count({<Resource -={'A','B' }>}ID)
Thanks
BKC
Hi,
In your set analysis you are hard coded for count of ID where Resource is A or B
There fore after making any selection Count is not changing.
IF want to change your count on the basis of Selection just use
count(ID)
Regards
hic Please comment
Thank you in advance
Hi,
In your set analysis you are hard coded for count of ID where Resource is A or B
There fore after making any selection Count is not changing.
IF want to change your count on the basis of Selection just use
count(ID)
Regards
Hi
you are using Set analysis to fix your scope to A and B values.
So of course Resource selection won't change the result WHICH IS SET
If you want to make a count of ID just (count(ID)) then select resources, it will change
best regards
Chris
Hi
In expression =count({<Resource= {'A','B' }>}ID)
You have added the count of Resource A and B, which is equal to 8. therefore it is counting it as 8.
The expression is doing exactly what you told it too!
What did you actually want it to do?
Andy
If you want to count only Resources A and B and take selections into account, this expression is probably what you need:
=count(if(Resource='A' or Resource='B',ID))
I think you want the intersection. Try
=count({<Resource *= {'A','B' }>}ID)
Using the * let's you select among the items in your set, but not outside those items.
mike
EDIT PS The editor will show a red underline indicating bad syntax. It's a bug in the editor that Qlik hasn't fixed for years.
I am just comparing when I use count({<Resource -={'A','B' }>}ID) then my selection is reflecting but in = its not.
So wanted to why its happening .
Thanks All.
- Exclusion Returns records that belong to the first but not the other of the two set identifiers.