topic How to change formula with a specific selection? in QlikView

How to change formula with a specific selection?

Fri, 08 Jun 2012 07:05:32 GMT

When I have one selection selected eg. a product I want to change the expression used so that it uses another variabel in that expression.

Eg:

LGD*K when product x is selected

LGD*K2 when product y is selected.

Or if there is another smarter way to go about this issue ?

Fri, 08 Jun 2012 07:17:44 GMT

Hi,

try with "Getfieldselections(Field)" to know which product you select.

For instance:

IF(Getfieldselections(Field) = 'X', LGD*K)

Hope it helps

Giampiero

jagan — Fri, 08 Jun 2012 08:14:08 GMT

Hi,

Try this

=If(Only(FieldName) = 'x', LGD*K, If(Only(FieldName) = 'y', LGD*K2, DefaultExpression))

Hope this helps you.

Regards,

Jagan.