topic Display all items whether sales or not in QlikView

Display all items whether sales or not

Mon, 06 Dec 2010 03:43:33 GMT

I am trying to design a chart which will show stock items that have NOT been sold as well as those that have. I know that I can use the dimension setting to "Show All Values" but I want to be able to apply a filter first to show only those items within the selected stock group.

The idea is to show what related items that a customer is not buying.

Thanks, Kevin

Display all items whether sales or not

Mon, 06 Dec 2010 08:56:42 GMT

Please go on chart property then after go presentation tab then uncheck the suppress zero values

Regards

Ashish

Display all items whether sales or not

Tue, 07 Dec 2010 04:54:03 GMT

Thanks for your reply, Ashish, but this does not achieve what I need. My example - I have 3000 stock items of which 50 are in a group called "Accessories". Of these 50 items, I have sold 30 to a customer. Having selected both that 1 customer and only the Accessories stock group, I want to show the sales values of the 30 items as well as showing 0 sales for the remaining 20 items. Is there a way of doing that?

When I uncheck the Suppress Zero-Values, I get a list of all 3000 items.

Thanks, Kevin