Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to show 'c' instead of '-' in the chart object.
The file is also attached.
Regards,
Zain.
The Null symbol box suggested by @jonathandienst is a good solution for most diagrams in QlikView, but not in the Pie chart. The Null symbol property is not available for that chart type.
An alternative solution is to implement NullAsValue, but in your case where you are using a calculated dimension it wont have an effect.
A second alternative could be to force the c value in some way in your calculated dimension, maybe adding an if statemet.
A third alternative solution is to skip the calculated dimension and instead create three expressions, named a, b and c.
I've attached attached a qvw where I've done this third alternative.
Go to Properties | Presentation and put a 'c' in the Null Symbol box.
The Null symbol box suggested by @jonathandienst is a good solution for most diagrams in QlikView, but not in the Pie chart. The Null symbol property is not available for that chart type.
An alternative solution is to implement NullAsValue, but in your case where you are using a calculated dimension it wont have an effect.
A second alternative could be to force the c value in some way in your calculated dimension, maybe adding an if statemet.
A third alternative solution is to skip the calculated dimension and instead create three expressions, named a, b and c.
I've attached attached a qvw where I've done this third alternative.
Thank a lot, gave me detail and multiple solutions.
i will check and revert to me if i need more.
Regards,
Zain.