topic Re: if Condition in QlikView

if Condition

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Goal:

Want to show the Article only when SoldQty>0 and soh>0

=if(aggr(sum(SoldQty),ArticleNo)>0 and aggr(sum(soh),ArticleNo)>0,ArticleNo)

(if i use above expression any not working as expected - currently it just works soldqty>0 condition)

Thanks,Dev

Anil_Babu_Samineni — Thu, 09 Feb 2017 04:01:48 GMT

What if we have written this? where you are implementing

If(aggr(sum(soh),ArticleNo)>0,ArticleNo)

devarasu07 — Thu, 09 Feb 2017 04:03:47 GMT

Hi Anil,

I need to apply both measure condition (sum(SoldQty)>0 and sum(soh)>0) . it's article level report. Tks

if i use only one measure in that if condition its working fine. need to apply both for my report requirement .

Note: if either one measure has <0 then it should display the article, i just don't show article when both measure <=0.

Thanks, Dev

Anil_Babu_Samineni — Thu, 09 Feb 2017 04:09:31 GMT

That case, It should work.

=if(aggr(sum(SoldQty),ArticleNo)>0 and aggr(sum(soh),ArticleNo)>0,ArticleNo)

Would you provide sample? And soh is all lower cases. If one condition works it should work for two conditions

Note: Here, Your condition seems only get article when the condition value is >0. Then, How you are expecting <0 will accessible

avinashelite — Thu, 09 Feb 2017 07:27:21 GMT

share the sample app ...will check and let you know