How to replace hyphen or ' - ' with 'No Data' in a Pivot Table?

[jblomqvist]

Hi all,

I have the following example:

How do I replace the Dashes with 'No Data' instead?

I tried this as a Measure but it does not work: If(Num(Sum(LineSalesAmount), '$##,###.00')=Null(), 'No Data', Num(Sum(LineSalesAmount), '$##,###.00'))

[Madhab77]

Hi Eng19872,

Thanks for the update, but unfortunately, it does not work. My Pivote table is a bit complicated one! If you analyse my screenshot of the table, you will find that, for a particular date there is no record, but in the next date records are there, so qlik is writing that records, which are available, but where there is no records, qlik simply putting a dash('-'). I think it is qlik's internal setting, like excel the default it keeps blank.

Thanks, Madhab.

[simon_minifie]

Hi, 

Have you tried using the ALT function? 

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFun...

Thanks,

Simon

[Madhab77]

Hi @simon_minifie ,  thanks for the update,. Yes, I tried with that also, but no luck.