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

how to combine these two exp and give them singlr name

exp1=       if([Customer Number Act]='789QWA','DIR',

exp 2 =    if([Customer Number]='9977YU','COMM', null()))

now i need to add these two exp and name it as total

and this total should show me the values of exp1+exp2

for example exp1=23  and exp2= 46

this one i will be using in the script

then total = 69

3 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Can you provide some more detail on what you want with some sample data?

Not applicable
Author

Can you try using doller sign expression?

eg =Sum(exp1+exp2)

manideep78
Partner - Specialist
Partner - Specialist

You can add both expressions directly

Expression_1 + Expression_2

You will get sum of those two Expressions.

Eg:  If([Customer Number Act]=................) + If([Customer Number]=..................)


                           23               +               46

So the result will be 69.