Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
nboccassini
Partner - Creator
Partner - Creator

show dimension value if set analysis is empty

Hi all,

I have a table like this:

LOCATIONtypevalue
a1100

 

In a pivot table (with location as dimension) I use the expression sum({<type={2}>}value) but the result is an empty table.

How show a result in pivot like

LOCATIONsum({<type={2}>}value)
a-

 

Regards

3 Replies
Taoufiq_Zarra

@nboccassinican you elaborate

type={2} assumes that you already have row with type=2 ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
nboccassini
Partner - Creator
Partner - Creator
Author

Yes, 

the fact is over 3 millions of row and I need ti calc the kpi sum({<type={2}>}value).

The problem is that I want to show '-' if the kpi is null (but showing only the selected location, so I can't use "show all value" properties)

Kushal_Chawda

@nboccassini  you can try below expression in pivot table

=sum({<Type={2}>}Value) + sum({1}0)

Note: Uncheck "Suppress zero-value" option from presentation tab of chart properties. You won't be able to show "-" but it will be "0" because  you are using Sum function. If you still want to show is as "-" then try below

=if(sum({<Type={2}>}Value) + sum({1}0) =0, '-', sum({<Type={2}>}Value) + sum({1}0))