topic Re: show dimension value if set analysis is empty in QlikView

show dimension value if set analysis is empty

nboccassini — Thu, 10 Dec 2020 10:32:47 GMT

Hi all,

I have a table like this:

LOCATION	type	value
a	1	100

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

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

Regards

Re: show dimension value if set analysis is empty

Taoufiq_Zarra — Thu, 10 Dec 2020 10:37:39 GMT

@nboccassinican you elaborate

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

Re: show dimension value if set analysis is empty

nboccassini — Thu, 10 Dec 2020 10:40:20 GMT

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)

Re: show dimension value if set analysis is empty

Kushal_Chawda — Thu, 10 Dec 2020 15:27:57 GMT

@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))