Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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
Specialist

@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!