Set analysis

[Anonymous]

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

[Anonymous]

hic‌ Please comment

Thank you in advance

[PrashantSangle · Accepted solution]

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

[#4]

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

[ashwanin]

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.

[awhitfield]

The expression is doing exactly what you told it  too!

What did you actually want it to do?

Andy

[Anonymous]

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))

[mikecrengland]

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.

[Anonymous]

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.

[awhitfield]

- Exclusion Returns records that belong to the first but not the other of the two set identifiers.