Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

How suppress when value is null for for bar chart

Hello Experts,

 

I have a straight table with following dimensions and expressions

Dimensions: Year, Product Type, Product Score, Country, region, Application Name, Product Name.

for all i have marked suppress when value is null check box

Expression: =num(SUM({$(vFilterStates)}{<cnum_of_employees-={"0"}>}cnum_of_employees), '#,###')

 

Now,

I have created bar chart with following dimensions and expressions

Dimensions: Year, Product Type

Expression: =num(SUM({$(vFilterStates)}{<cnum_of_employees-={"0"}>}cnum_of_employees), '#,###')

 

Now the problem is values are mismatching for table and chart.

because i was marked suppress when value is null check box for product score in straight table which is correct

But, how to do in bar chart i am not getting. I tried like this also then also it's not working

=num(SUM({$(vFilterStates)}{<cnum_of_employees-={"0"},cProductScore-={"0"}>}cnum_of_employees), '#,###')

 

Please help me out from this

 

Thank you in advance

Sudhakar

 

5 Replies
bvssudhakar
Creator III
Creator III
Author

@sunny_talwar please help me for this

sunny_talwar

Would you be able to share a sample?
bvssudhakar
Creator III
Creator III
Author

Hi Sunny,

file size is too long(21 MB) how to send can you please suggest

 

Thank you in advance

sunny_talwar

bvssudhakar
Creator III
Creator III
Author

Hi Sunny,

If possible can you share your mail id so that i can send you through email. Because i tried reduce data option data is giving confusion so with this may be it's difficult to analyse

 

Thank you