Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

selimkocak
New Contributor

Empty cell in the pivot table is it possible to zero?

Hello there,

Pivot tables dash fields with zero (0) Can we do.


Above(TOTAL SUM(debt),0,RowNo(TOTAL)) + Above(TOTAL SUM(credit),0,RowNo(TOTAL))

+

SUM(amount)


Ekran Alıntısı.JPG

1 Solution

Accepted Solutions
lakshmikandh
Valued Contributor II

Re: Empty cell in the pivot table is it possible to zero?

combination which are not having data in table are displayed as gaps or dashes . You can not show it as zero if you are not having data for that combination.

4 Replies
lakshmikandh
Valued Contributor II

Re: Empty cell in the pivot table is it possible to zero?

combination which are not having data in table are displayed as gaps or dashes . You can not show it as zero if you are not having data for that combination.

cesaraccardi
Valued Contributor

Re: Empty cell in the pivot table is it possible to zero?

Hi,

What if you replace the expression by sum({1} 0), does it display 0 values for all the cells? If that is the case then I think you can try something like:

sum({1} 0)

+

alt(

Above(TOTAL SUM(debt),0,RowNo(TOTAL)) + Above(TOTAL SUM(credit),0,RowNo(TOTAL))

+

SUM(amount)

,0)

rupamjyotidas
Valued Contributor

Re: Empty cell in the pivot table is it possible to zero?

Maybe ALT() funciton can help you, if I understand your problem

Alt(your equation, 0)

Below is the help

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/ConditionalFunctions/alt.htm

selimkocak
New Contributor

Re: Empty cell in the pivot table is it possible to zero?

Thank you so much

Community Browser