Pivot Table

[maniram23]

Hi Experts,

How replace "Null Symbols( - )  to Zero ( 0 ) values in pivot table in Qlik sense.

i am trying a lot. But i didn't get an exact output.

Please help me.

Regards,

[arulsettu]

may be try like this

use it in calculated dimension

if(isnull(dimension),'0',dimension)

[maniram23]

Hi arul,

Thanks for your replay.

I need an expression wise. Not a dimension wise.

For Example in qlikView:

In qlikview --- Pivot Table --- Presentation Tab ---- Left side  down corner ---- Null Symbol option is there  like that .

I Need the same "Null Symbol"  performance in Qlik Sense also.

regards,

[rahulpawarb]

Hello Mani,

Hope you are doing good!

I agree with Arul. You can make use of if(isnull(dimension),'0',dimension)

However, if you are loading data from ODBC source then use, SET NULLDISPLAY='0'; This will substitute all NULL values from the ODBC data source on the lowest level of data input. This will save efforts for writing validation check at every place.

NOTE: The use of NULLDISPLAY only affects data from an ODBC data source.

Regards!

Rahul

[maniram23]

Hi Rahul,

Thanks for your replay.

See the above image. there null Symbol ( - ) are there.

there i want to Replace " 0 " Value.

Regards,

[arulsettu]

post your application

[manidhana90]

Hi mani,

Hope this will help u,

Edit your script while loading

If(Dimension='-',0,Dimension) as fieldname;

this might help you.

Regards,

manikandan

[simondachstr]

Checkout the alt function alt(expression,'0')