topic Re: Message when all values are zero in QlikView

Message when all values are zero

Anonymous — Tue, 22 Jul 2014 08:56:55 GMT

I am creating a pivot table. I am suppressing zero-values as I don't want a long list with 0 (most of my values are zero). Therefore I get a short list with the relevant non-zero values. This is fine, but in some cases all the values is zero, and I do not get any values at all. In this case only the headline is shown. For this case it would be useful if I could show a special message to the users. Does anyone know how I can do this?

Re: Message when all values are zero

simondachstr — Tue, 22 Jul 2014 09:17:59 GMT

Create a calculation condition in the General tab. If your used expression is 0 in total, then don't calculate the chart and display a customized error message instead.

Re: Message when all values are zero

senpradip007 — Tue, 22 Jul 2014 09:19:06 GMT

Use customize error message

Re: Message when all values are zero

Anonymous — Tue, 22 Jul 2014 09:35:02 GMT

Calculation condition or conditional show with text box are the easiest solution, but if you really want it the way it is in screenshot:

Create calculated dimension: =IF(aggr(Sum(Approvals),YearMonth)=0, 'Nothing is approved', YearMonth)

Red color to text color: =IF(Sum(Approvals)=0, rgb(255,0,0))

Then we need two expressions with conditionals:

1st:

Condition: Sum(Approvals)<>0

Expression: Sum(Approvals)

2nd:

Condition: Sum(Approvals)=0

Expression: ' '

Calculated dimensions can sometimes bring performance issues.

Re: Message when all values are zero

Siva_Sankar — Tue, 22 Jul 2014 09:40:35 GMT

in chart properties,general tab, under calculated condition write something like =If(sum(approvals)>0, 1, 0)

and then click on error message button in general tab, click calculation conditions unfulfilled, and write your custom message below.

see the attached example

Re: Message when all values are zero

jagan — Tue, 22 Jul 2014 09:43:35 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: Message when all values are zero

Anonymous — Tue, 22 Jul 2014 11:16:13 GMT

I can't see any attached file...

Re: Re: Message when all values are zero

jagan — Tue, 22 Jul 2014 13:50:38 GMT

Hi,

Attached again.

Regards,

Jagan.