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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
PoojaS
Contributor II
Contributor II

Display 0 in a table only when it comes from the source, otherwise should not display 0

Hi,

I attached the data which i used and also i have attached the table screenshot.
for the company C , we dont have any data. but in the table we can see 0 as a value.
so i dont wnat to show the 0 for the company C. i want to show 0 only for B as it has the values 0 for sales.
Could you please help me with the solutions.

PoojaS_0-1715778767722.png

PoojaS_1-1715778876140.png

 

 

Labels (7)
2 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Add to your expression set analysis 

…., sales={“*”}

 

cheers Lech, 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 to the problem.
MatheusC
Specialist II
Specialist II

@PoojaS 
maybe this:

sum({<category={'Mobile'},sales-={""}>}sales)

Regarts, Matheus



Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!