topic Chart requirements in QlikView

Chart requirements

suvechha_b — Tue, 12 Jan 2016 08:55:18 GMT

How can I show the field if it doesnot have values .

Please see the below requirement :

the first reporting code/item doesnot have any order value , thus it not showing in the chart.

My requirements is, I need to show the order row with '0' values .

Re: Chart requirements

jonathandienst — Tue, 12 Jan 2016 08:58:30 GMT

Uncheck the Suppress Zero Values option in Chart Properties | Presentation.

Re: Chart requirements

Chanty4u — Tue, 12 Jan 2016 09:02:30 GMT

unchk suppess

Re: Chart requirements

PrashantSangle — Tue, 12 Jan 2016 09:02:37 GMT

Hi,

Go to Chart Property -> Presentation -> un-tick ->

Supress Zero Values and Supress Missing ,Populate Missing Cell.

Regards

Re: Chart requirements

ahmar811 — Tue, 12 Jan 2016 09:03:52 GMT

hi suvechha.b

try this step on your chart

1-Right click on your chart select properties

2-Go to Presentation tab

3-Uncheck the Supress Zero-Values (show as below)

hope you these help you

Thank & Regards

Ahmar Ansari

Re: Chart requirements

suvechha_b — Tue, 12 Jan 2016 09:04:46 GMT

But the particular Item is not having order data , then how can I show '0' ?

Re: Chart requirements

jagan — Tue, 12 Jan 2016 09:04:55 GMT

Hi,

If there is no records with 0 then you have to manually insert the rows with zero values and then uncheck Supress Zero Values option in Chart Properties -> Presentation

Hope this helps you.

Regards,

jagan.

Re: Chart requirements

suvechha_b — Tue, 12 Jan 2016 09:05:13 GMT

But the particular Item is not having order data , then how can I show '0' ?

Re: Chart requirements

suvechha_b — Tue, 12 Jan 2016 09:05:21 GMT

But the particular Item is not having order data , then how can I show '0' ?

Re: Chart requirements

suvechha_b — Tue, 12 Jan 2016 09:06:26 GMT

But the particular Item is not having order data , then how can I show '0' ?

Can you help me how to manually insert the rows with zero. ?

Re: Chart requirements

suvechha_b — Tue, 12 Jan 2016 09:31:50 GMT

But the particular Item is not having order data , then how can I show '0' ?

Can you help me how to manually insert the rows with zero. ?

Chart requirements

Re: Chart requirements

ahmar811 — Tue, 12 Jan 2016 09:32:46 GMT

I you want to show Zero if data in not available

just put '0' on Null symbol and Missing symbol in Presentation tab

and another option is you can put the condition on Dimension like

if(isnull(order) or order=' ' or order='','0',order)

hope this help you

Re: Chart requirements

suvechha_b — Tue, 12 Jan 2016 09:41:23 GMT

Order field is not dimension field .

Order is calculative field :

=sum({<[Fin Year]=,[Fiscal Month]=,[Sale Month]={$(vCurrMonth)} >} $(vCalc))

and there are many calculative fields.

Re: Chart requirements

Kushal_Chawda — Tue, 12 Jan 2016 09:52:35 GMT

= if( isnull(YourExpression),0,YourExpression)

alt(YourExpression,0)

Now go to presentation and uncheck suppress zero value

Re: Chart requirements

jagan — Wed, 13 Jan 2016 01:12:28 GMT

Hi,

Check this link

How to display 0 when there is no record

Regards,

Jagan.

Re: Chart requirements

Wed, 13 Jan 2016 05:53:15 GMT

You have to uncheck that property as said by other community members.

You can write our expression as sum(0) + your expression

Thanks

Khushboo