Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a basic requiremnt of showing values in pivot chart when expression returns 0.
E.g. If Expression of pivot table is Sum(Amnt) and for certain selection this return 0. then QlikView will diaplay the message
'No data To Display'. But my requiremnt is to show the data in pivot table with 0 as expression value.
Please find attched excel sheet for the details of the problem. also atteched is the sample application in which i'm trying to get the same.
Hi,
All you have to do is go to properties -> dimensions -> click on product and check Suppress when value is null and show all values.
Hope this will help you.
Regards,
Kaushik Solanki
Thanks for reply Kaushik,
but i cant apply the settings given by you . this is showing one extra column with value 0 in pivot table.
also there can be Product selection in a list box similar ti time selection.. in that case 'Show All Values' will be incorrect.
any idea?
Hi,
I think that only method to solve your problem are to change your script.
With you generate others records with 0 values on field "ShipingQuantity" and after concatenate with you table "Fact", the result show all values.
See Attachments
Hi Sparten B.
Try this option too.
Go to Presentation Tab, at the bottom there is an option "Suppress Zero-Values".
Hope this help.
Regards!
Hi Eduardo Correa,
The changes in the script seem to have worked. But I am not able to understand how the changes helped to avoid the extra column with 0 in the pivot table. I am also not able to explain why there was an extra column.
Hi,
The value "0" are demonstrate but don't are "0".
In properties / Presentation change the values of fields:
"Null Symbol" and "Missing Symbol" to "X" AND "Y"
You will see that values are null and missing.
Maybe pivot table make a joined with the values of dimensions and demonstrate the result.
Thank you for the explanation.
Thank u all,
Eduardo Correa,
I can not change the script, bcoz calculation of shipping quantity requires some other calculations also in my case,i'm not directly using this column for expression.
Emmanuel Prieto,
I've already tried "Suppress Zero-Values" option at the bottom of Presentation Tab.
this will show zero values when no time period or product is selected.. but as soon as i select time axis, zero values are supressed.
e.g. if for 2010 and 2011 values are 0 and 1.pivot table is:
Product Time 2010 2011
Mouse 0 1
Printer 0 1
when Printer is selected pivot table displty should be:
Product Time 2010 2011
Printer 0 1
But, the current display i'm getting is:
Product Time 2011
Printer 1
I'm really stuck up at this point.
Hi, do you can to post your qvw (using reduce data, scrambling some fields)?