Progressive if ladder

sujit_nath — Mon, 15 Oct 2018 12:12:08 GMT

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?

Re: Progressive if ladder

bramkn — Mon, 15 Oct 2018 12:19:55 GMT

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

topic Progressive if ladder in QlikView

Progressive if ladder

Re: Progressive if ladder