Progressive if ladder

[sujit_nath]

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?

[bramkn]

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