Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple expressions

Hello,

I am new to QlikView and I would appreciate some help considering expressions. I have three fields and every field had 2 expressions for its value. Is it possible to assign multiple expressions to one field?

For example: X=Y*Z and X=W-Y

I stored two of those formulas into variables and I have values $(X1) and $(X2). Is there a way I can assign both formulas to one field, so the field value is calculated based on both formulas?

I would really appreciate some help

Thank You!

12 Replies
Not applicable
Author

by input fields in a table

jagan
Luminary Alumni
Luminary Alumni

Hi,

Attach some sample file and your expected output.

Regards,

Jagan.

Not applicable
Author

This is an example file I'm working on. Basicaly, I have created formulas in variables. I would like to apply 2 formulas per table field. For example, Delta dimension should satisfy $(Delta1) and $(Delta2) expressions