Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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
Anonymous
Not applicable

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