Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If we use generic if ladder in qlikview, like if(A='2','true',(if(B='3','B True',if(C='4','C True','No condition fullfilled'))))
However the statement shown is just an example, if we create count of a field, suppose quantity, it will be like:
A-20
B-10
C-5
which is an overlap. I want if ladder and then counts in such a way that it states the count as:
Count A , from that set, count B and from the ser B, count C.
Is there a way to achieve that?
Not completely sure what you want to do. But I like to use pick(Match(value,'a','b','c'),'do something when a','do something when b,'do something when c'))
Hope this helps