Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
reivax31
Partner - Creator III
Partner - Creator III

Find number of occurence in several fields

Hi Qlikers,

I would like to find a way to count how many time I find a specific value in several fields. My table looks like this

LOAD

ID,

A,

B,

C,

D,

etc ...

Resident MyData;

How can I calculate how many time I find for each ID (unique in my table) how many time I find value 'x' in dimenssion A, B, C, D, etc...

For information, I have more than 200 fields so I try to find and easy way instead of doing something like :

     if(A like '*x*',1,0)  +   if(B like '*x*',1,0)  +   if(C like '*x*',1,0)  + etc....

Also, one last thing, 'x' is unique in each dimenssion.


Thanks for your help.

1 Solution

Accepted Solutions
sunny_talwar

May be to do this... you can first use The Crosstable Load to convert your 200 something fields into a single field... and then count?

View solution in original post

3 Replies
jonnieyacoub
Creator
Creator

something like this?:

COUNT({<[ID]={'A'}>}[ID])

sunny_talwar

May be to do this... you can first use The Crosstable Load to convert your 200 something fields into a single field... and then count?

reivax31
Partner - Creator III
Partner - Creator III
Author

Hi,

Perfect the cross table solution. I never used it for this purpose but nice move .

Then I performed a Group By on my ID and I had it done.

Thanks