This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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
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?
View solution in original post
something like this?:
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.