I need to replace empty value '-' by 0 in pivot table.
Unfortunately, it does not work.
Many thanks for your help.
In Qliksense, can we show '0' instead of '-' in pivot tables when there are no such records?
I have tried but it's not working.
Thank you for your help.
Thanks for your return.
I have already check this post but without success.
In the old days we used to create zero-values in the datamodel in order to avoid the '-'s......
Maybe try this in your edit script?
If(Len(Trim(YourFieldName)) = '-', 0,YourFieldName ) as New_FieldName
I think that he's trying to eliminate the '-' in the measure not the dimension..
And I do not think that this is possible..
Unfortunately not working.
Can you please post an example?
Many thanks in advance.
There's always the option to create ones own extension .....
Retrieving data ...