topic Re: Showing 0 values in bar chart in QlikView

Showing 0 values in bar chart

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

Hi Experts,

I have expression like following

count(DISTINCT{<ows_Modified={"<=$(=timestamp(Today()))>=$(=timestamp(MonthStart(Today(),-$(vShowInputMonths))))"},id={'VERSION_HISTORY'},SHP_CAISFilter-={''},SHP_Status= {"*Closed*"}>}(aggr(min(ows_Modified),id,ows_ModifiedHistory,SHP_CAISFilter,SHP_Status,[ows_Problem Ticket])))

from above expression I'm unable to show value 0 on bar chart. Can anyone help me to in this ?

Thanks,

Pooja

Re: Showing 0 values in bar chart

manoj217 — Fri, 17 Aug 2018 08:21:17 GMT

Try this:

=count(DISTINCT({<ows_Modified={"<=$(=timestamp(Today()))>=$(=timestamp(MonthStart(Today(),-$(vShowInputMonths))))"}
,id={'VERSION_HISTORY'}
,SHP_CAISFilter-={''}
,SHP_Status= {"*Closed*"}>}
(aggr(min(ows_Modified),id,ows_ModifiedHistory,SHP_CAISFilter,SHP_Status,[ows_Problem Ticket]))))

Re: Showing 0 values in bar chart

Anonymous — Fri, 17 Aug 2018 08:51:47 GMT

Hi Manoj,

Can I know that what new thing/change you have done in existing expression?

Thanks,

Pooja

Re: Showing 0 values in bar chart

PrashantSangle — Fri, 17 Aug 2018 09:02:40 GMT

Hi,

Uncheck supress Zero- values from bar chart property > Presentation.

Regards,

Re: Showing 0 values in bar chart

Anonymous — Fri, 17 Aug 2018 09:03:54 GMT

Hi Prshant,

That is done .

Thanks,

Re: Showing 0 values in bar chart

pradosh_thakur — Fri, 17 Aug 2018 09:04:19 GMT

check - dimension -> Show all values

check - presentation -> suppress zero values

regards

Pradosh

Re: Showing 0 values in bar chart

PrashantSangle — Fri, 17 Aug 2018 09:22:06 GMT

good.

Regards,

Re: Showing 0 values in bar chart

Anonymous — Fri, 17 Aug 2018 09:28:01 GMT

Hi Pradosh,

That is already done .

Thanks,

Re: Showing 0 values in bar chart

Anonymous — Fri, 17 Aug 2018 09:30:55 GMT

Hi Team,

Can anyone help in this, as I have mentioned that presentation-- supress Zero- values is allready done but still unable to show 0 value on bar chart.

Thanks,

Re: Showing 0 values in bar chart

manoj217 — Fri, 17 Aug 2018 09:32:43 GMT

why r u using this $(=timestamp(Today()))>=$(=timestamp(MonthStart(Today(),-$(vShowInputMonths))))"}, condition

Re: Showing 0 values in bar chart

Frank_Hartmann — Fri, 17 Aug 2018 09:34:43 GMT

what happens if you add a second expression e.g.

avg({1}1/1)

and set this expression to invisible?

Re: Showing 0 values in bar chart

pradosh_thakur — Fri, 17 Aug 2018 09:59:52 GMT

did you check show all values in the dimension ? You need to enable this .

Re: Showing 0 values in bar chart

BalaBhaskar_Qlik — Fri, 17 Aug 2018 10:30:18 GMT

May be use single quotes in wild search like:

=count(DISTINCT{<ows_Modified={"<=$(=timestamp(Today()))>=$(=timestamp(MonthStart(Today(),-$(vShowInputMonths))))"},

id={'VERSION_HISTORY'},SHP_CAISFilter-={''},SHP_Status= {'*Closed*'}>}(aggr(min(ows_Modified),id,ows_ModifiedHistory,SHP_CAISFilter,SHP_Status,[ows_Problem Ticket])))

Re: Showing 0 values in bar chart

kumarravi — Wed, 27 Apr 2022 16:06:57 GMT

HI @Anonymous,

It can be the combination of the following:

Show all values in dimension Tab

Uncheck suppress zero value and check zero on bar