Pivot table with hipen instead 0

[Farsana]

Team,

In below table i want to display 0 instead -, how to do, i tried with multiple options including Alt but still no luck.

Current expression : if(count({<name= $::name,[Doctor State]=$::[Doctor State]>}[Doctor State])> 0,1,0)

Any suggestions to sort this issue. Thanks in advance

[MatheusC · Accepted solution]

@Farsana 
My suggestion is to use the new pivot table in custom objects, in which you will be able to give other values ​​to this missing data, in the Chart Tab in Presentation.

*see if it is available in your version*

- Matheus

[Farsana]

Thanks @MatheusC  it worked 🙂

[Farsana]

@MatheusC when i am trying to download the data into excel,  0 converted to hipen . Any options we have in Qlik to download as 0 itself

Thanks again 

[MatheusC]

As far as I know, no. If it's feasible or maybe you've already fixed it in Excel, that would be the solution. 👍

- Regards, Matheus

[brunobertels]

Hi 

not tested but may be try this 

 if(count({<name= $::name,[Doctor State]=$::[Doctor State]>}[Doctor State]) + SUM({1}0) > 0,1,0)

[Farsana]

No 😞