topic Re: How suppress when value is null for for bar chart in QlikView

How suppress when value is null for for bar chart

bvssudhakar — Sat, 16 Nov 2024 05:09:07 GMT

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

Re: How suppress when value is null for for bar chart

bvssudhakar — Fri, 23 Nov 2018 13:29:59 GMT

@sunny_talwar please help me for this

Re: How suppress when value is null for for bar chart

sunny_talwar — Fri, 23 Nov 2018 13:36:54 GMT

Would you be able to share a sample?

Re: How suppress when value is null for for bar chart

bvssudhakar — Fri, 23 Nov 2018 13:59:54 GMT

Hi Sunny,

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

Thank you in advance

Re: How suppress when value is null for for bar chart

sunny_talwar — Fri, 23 Nov 2018 14:02:18 GMT

Is this QlikView? If it is, try this

Preparing examples for Upload Reduction and Data Scrambling

Re: How suppress when value is null for for bar chart

bvssudhakar — Fri, 23 Nov 2018 14:27:26 GMT

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