Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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
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
Thanks @MatheusC it worked 🙂
@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
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
Hi
not tested but may be try this
if(count({<name= $::name,[Doctor State]=$::[Doctor State]>}[Doctor State]) + SUM({1}0) > 0,1,0)
No 😞