Solved: Conditionaly enable disable expression in qv chart - Qlik Community

milindnikumbh · ‎2017-10-28

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.

Anil_Babu_Samineni · ‎2017-10-28

Or this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

tresesco · ‎2017-10-28

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

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

Anil_Babu_Samineni · ‎2017-10-28

Or this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

milindnikumbh · ‎2017-10-28

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 · ‎2017-10-30

Thanks you so much.

tresesco · ‎2017-10-30

Milind Nikumbh wrote:

...

Please suggest.

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