Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master III
Master III

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.

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.


Creator
Creator

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

Creator
Creator

Thanks for you reply, this worked great