SHOW ALL VALUES

[oseimuduame]

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?

[kaushiknsolanki]

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

[oseimuduame]

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.

[isingh30]

Please share your data or app.

Thank you!

[Digvijay_Singh]

May be try this, add + sum({1} 0) in the expression -

What does it mean sum({1} 0)?

[sasiparupudi1]

Try Alt(Sum(ITEM_PRICE) ,0)