Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Message when all values are zero

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?

Untitled.png

7 Replies
simondachstr
Luminary Alumni
Luminary Alumni

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.

senpradip007
Specialist III
Specialist III

Use customize error message

Anonymous
Not applicable
Author

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.

Siva_Sankar
Master II
Master II

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

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.

Regards,

Jagan.

Anonymous
Not applicable
Author

I can't see any attached file...

jagan
Luminary Alumni
Luminary Alumni

Hi,

Attached again.

Regards,

Jagan.