topic Re: Conditionaly enable disable expression in qv chart in QlikView

Conditionaly enable disable expression in qv chart

milindnikumbh — Wed, 25 Nov 2020 16:16:04 GMT

Dear Experts ,

I am new to QV. I am not able to hide expression conditionally in QV bar graph.

Following condition is returning me 999 for all group levels.

=if(GetCurrentField('SH_LI_MTH_DIE') = 'DIE NO.' , 100, 999) \

Please help me on this.

Best Regards,
Milind.

tresB — Sat, 28 Oct 2017 09:30:55 GMT

Try removing quotes ('') from group name and try like:

=if(GetCurrentField(SH_LI_MTH_DIE) = 'DIE NO.' , 100, 999)

Anil_Babu_Samineni — Sat, 28 Oct 2017 11:38:30 GMT

Or this?

=if(Match(GetCurrentField(SH_LI_MTH_DIE), 'DIE NO.') , 100, 999)

milindnikumbh — Sun, 29 Oct 2017 02:59:16 GMT

Hello ,

I tried both the options in variable and text object individually but still not working.

when I called variable in text object its returning "-" ( Dash ) but when I put same code in text object its returning 999 value.

Please suggest.

Thanks you.

Regards,

Milind.

milindnikumbh — Mon, 30 Oct 2017 08:39:18 GMT

Thanks you so much.

tresB — Mon, 30 Oct 2017 08:40:46 GMT

Milind Nikumbh wrote:

...

Please suggest.

I suggest to share your sample qvw so that we can have a look into the issue.