topic Re: Set analysis in QlikView

Set analysis

Anonymous — Thu, 09 Apr 2015 13:05:33 GMT

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

Re: Set analysis

Anonymous — Thu, 09 Apr 2015 13:16:26 GMT

hic‌ Please comment

Thank you in advance

Re: Set analysis

PrashantSangle — Thu, 09 Apr 2015 13:19:39 GMT

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

Re: Set analysis

Thu, 09 Apr 2015 13:21:56 GMT

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

Re: Set analysis

ashwanin — Thu, 09 Apr 2015 13:23:30 GMT

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.

Re: Set analysis

awhitfield — Thu, 09 Apr 2015 13:31:54 GMT

The expression is doing exactly what you told it too!

What did you actually want it to do?

Andy

Re: Set analysis

Anonymous — Thu, 09 Apr 2015 13:35:38 GMT

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

Re: Set analysis

mikecrengland — Thu, 09 Apr 2015 13:41:17 GMT

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.

Re: Set analysis

Anonymous — Thu, 09 Apr 2015 13:55:45 GMT

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.

Re: Set analysis

awhitfield — Thu, 09 Apr 2015 13:58:46 GMT

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