How suppress when value is null for for bar chart

[bvssudhakar]

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

[bvssudhakar]

@sunny_talwar please help me for this

[sunny_talwar]

Would you be able to share a sample?

[bvssudhakar]

Hi Sunny,

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

Thank you in advance

[sunny_talwar]

Is this QlikView? If it is, try this

Preparing examples for Upload Reduction and Data Scrambling

[bvssudhakar]

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