Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ksk278074
Contributor III
Contributor III

Remove the entire row when all key figures are equal to 0

HI All,

How to remove the entire Row when all key figures are equal to 0

for reference please see the below table

 

product ,slaes ,cost, item
A,1,0,hello
b,0,1,hai
c,1,1,bang
d,0,0,hyd

 In the above example 4 th row contains all key figures are 0 so i dont want entire row .

My question is how to delete the entire row?

O/p:

product ,slaes ,cost, item
A,1,0,hello
b,0,1,hai
c,1,1,bang

THanks in advance 

2 Replies
Anil_Babu_Samineni

Try this way?

Load product, slaes, cost, item From table where slaes>0 and cost>0

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ksk278074
Contributor III
Contributor III
Author

i want to edit in front end