Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenhasson
Creator
Creator

Block 0 value lines?

abc.JPG

In above chart, I want to remove lines where there is no delta in qty.

Detla qty is    =sum(OurReqQty)-sum(Open_Order_Quantity__c)

I have tried this 

if( sum({1}OurReqQty)-Sum({1}Open_Order_Quantity__c)=0,0,sum(OurReqQty)-Sum(Open_Order_Quantity__c))

and switched off 'show zero values' in Add-ons, but didn't work. A similiar approach worked on another app recently, but not this time.

Any help appreciated. thanks.

4 Replies
Digvijay_Singh

Do you have any other measure with non zero values, I think it only switches off zero values when all measures in a row produces 0 values.

john_obrien
Contributor III
Contributor III

Stephen,

You will need to wrap all the expressions in this chart in If statements like this:

if( sum(OurReqQty)-Sum(Open_Order_Quantity__c)=0,0,sum(OurReqQty)-Sum(Open_Order_Quantity__c))


if( sum(OurReqQty)-Sum(Open_Order_Quantity__c)=0,0,sum(EpicorValue))


I don't think the set analysis expression is needed in the If condition - if( sum( {1} ...

Without it, the If condition will use the same set of data that the rest of the expression does, so each row shows or hides as it should.


I hope that helps.


stephenhasson
Creator
Creator
Author

Thanks for you reply, now resolved, as I removed the other columns.

stephenhasson
Creator
Creator
Author

Thanks for you reply, this worked great