Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Evening guys,
I have a question here please;
is it possible i show all values in a chart like i have 5 Stores and 3 of the Stores sold a particular item but Using Sum(ITEM_PRICE) gives me only the 3 Stores that sold the item.
I want to be able to have a chart that will show all stores irrespective of whether they sold the Item or Not.
Any help please?
Hi,
Are you using Qlikview or Qlik Sense.
If QlikView then
Go to chart properties -> Presentation Tab -> Uncheck "Supress Zero-Values"
If QlikSense then
Go to Properties on right panel -> Add-ons -> Data Handling -> Check "Include Zero Values"
Regards,
Kaushik Solanki
Hello Kaushik,
I am using Qlikview and i have tried that still giving me Items with Values only. Below is what my result looks like and i have about 22 Stores. I want to have all stores even if they made no sales.
Please share your data or app.
Thank you!
May be try this, add + sum({1} 0) in the expression -
Try Alt(Sum(ITEM_PRICE) ,0)