Expression with two different formulas? - Qlik Community

qlikuser222 · ‎2017-10-25

Hi All,

Can we create a expression with two different formulas? like few dimensions should have formula1 one and rest other with formula2 within same expression?

PFA which has example..

Thanks

Anil_Babu_Samineni · ‎2017-10-25

Like this?

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

qlikuser222 · ‎2017-10-26

‌Thanks for reply ,

can we do it without hardcoding the ID's . We have some million records and can't hardcode all the ID's

Thanks

Anil_Babu_Samineni · ‎2017-10-26

How we know which ID's need to calculate for one and left are the one, May be create bucket for that and use the same expression using Bucket field.

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