Pivot table Qlik Sense (urgent)

[nicogene]

Dear all,

I need to replace empty value '-' by 0 in pivot table.

Unfortunately, it does not work.

Many thanks for your help.

Kind regards,

Nicolas.

[barry_stevens]

In Qliksense, can we show '0' instead of '-' in pivot tables when there are no such records?

[shraddha_g]

Try,

if(Len(Expression)<1,0,Expression)

or

Alt(Expression,0)

or

if(isnull(Expression),0,Expression)

[nicogene]

Hello,

Thanks for your return.

I have already check this post but without success.

Thank you for your help.

Regards,

Nicolas.

[nicogene]

Hello,

I have tried but it's not working.

Thank you for your help.

Regards,

Nicolas.

[klausskalts]

In the old days we used to create zero-values in the datamodel in order to avoid the '-'s......

[MK9885]

Maybe try this in your edit script?

If(Len(Trim(YourFieldName)) = '-', 0,YourFieldName )  as New_FieldName

[OmarBenSalem]

I think that he's trying to eliminate the '-' in the measure not the dimension..

And I do not think that this is possible..

[klausskalts]

There's always the option to create ones own extension .....

[nicogene]

Unfortunately not working.

Can you please post an example?

Many thanks in advance.

Kind regards,

Nicolas.