Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
something like this?:
COUNT({<[ID]={'A'}>}[ID])
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?
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