topic Re: SHOW ALL VALUES in QlikView

SHOW ALL VALUES

oseimuduame — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: SHOW ALL VALUES

kaushiknsolanki — Thu, 01 Mar 2018 18:52:32 GMT

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

Re: SHOW ALL VALUES

oseimuduame — Thu, 01 Mar 2018 19:23:31 GMT

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.

Re: SHOW ALL VALUES

isingh30 — Thu, 01 Mar 2018 19:31:47 GMT

Please share your data or app.

Thank you!

Re: SHOW ALL VALUES

Digvijay_Singh — Thu, 01 Mar 2018 19:57:31 GMT

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

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

Re: SHOW ALL VALUES

sasiparupudi1 — Mon, 05 Mar 2018 14:18:42 GMT

Try Alt(Sum(ITEM_PRICE) ,0)