topic Changing null from '-' using text in chart in QlikView

Changing null from '-' using text in chart

Wed, 25 May 2011 20:17:24 GMT

I'm working on an ERP dashboard and need to change the value of text-in-chart for my gauge chart from '-' to 'No Selection' as the users find it confusing when no field is selected, I've tried to implement an = If statement but can't seem to get it to work.

This is the current expression:

=If(IsNull(GetCurrentField([SH Group]), 'No Selection', Num($(Rule1Dial),'#,##0.00%')

The default Null display is still '-' and my calculation no longer runs, however when the expression just reads

=Num($(Rule1Dial),'#,##0.00%')

I get the correct weighted percentage, but the Null value is still a hyphen. Would appreciate any help.

Re: Changing null from '-' using text in chart

johnw — Wed, 25 May 2011 22:58:21 GMT

Maybe this?

=if(len($(Rule1Dial)),num($(Rule1Dial),'#,##0.00%'),'No Selection')

Changing null from '-' using text in chart

rwunderlich — Wed, 25 May 2011 23:31:27 GMT

I like John's solution. However I'll point out that getCurrentField() is probably the wrong function to use in your test. GetCurrentField returns the current field of a group -- which would never be null.

-Rob

Changing null from '-' using text in chart

kaushiknsolanki — Thu, 26 May 2011 06:43:42 GMT

Hi,

Let me tell you one thing about your expression that you have missed one ')' .

You can use the below expression.

=If(IsNull(GetFieldSelections([SH Group])), 'No Selection', Num($(Rule1Dial),'#,##0.00%'))

Here if the selection in SH Group is null then it will return No Selection or else the Num($(Rule1Dial),'#,##0.00%')

Regards,

Kaushik Solanki

Changing null from '-' using text in chart

Thu, 26 May 2011 12:53:44 GMT

Thank you guys, works great now