Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
pranaview
Contributor

How to execute an expression based on a specific value in a dimension

Hi Guys,

Problem :  I want to perform two different expressions in a chart based on what user selects in a different field.

So, i thought maybe I can use GetCurrentField() function but it did not work. 

=If(GetCurrentField(Status) = 'Not Met' , Expression 1,Expression 2)

Please let me know if there's any way I can achieve this.

Thanks!

Pranav

 

4 Replies
JandreK
New Contributor II

Re: How to execute an expression based on a specific value in a dimension

Hi 

Try GetFieldSelections(Status)

Regards

anushree1
Valued Contributor

Re: How to execute an expression based on a specific value in a dimension

Please use GetFieldSelections instead of getcurrentfield in your if condition

pranaview
Contributor

Re: How to execute an expression based on a specific value in a dimension

Worked!! Thanks!!
pranaview
Contributor

Re: How to execute an expression based on a specific value in a dimension

Thanks Anushree!! It worked.