Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@sunny_talwar please help me for this
Hi Sunny,
file size is too long(21 MB) how to send can you please suggest
Thank you in advance
Is this QlikView? If it is, try this
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