topic Re: Multiple formula in one table in QlikView

Multiple formula in one table

Wed, 20 May 2015 10:47:09 GMT

Would like to know how and what's the best approach to create result as per the table below in QV. Any suggestion is much appreciated!

The description is basically "hard-coded". While each row is using different formula to calculate.

maxgro — Wed, 20 May 2015 16:41:40 GMT

dimension

valuelist('1.Direct Premium Amount', '2.Assumed Premium Amount')

expression

if(valuelist('1.Direct Premium Amount', '2.Assumed Premium Amount')='1.Direct Premium Amount', formula 1,

if(valuelist('1.Direct Premium Amount', '2.Assumed Premium Amount')='2.Assumed Premium Amount', formula 2

))

add 3 and 4

Anonymous — Wed, 20 May 2015 16:50:13 GMT

Another way:

No dimensions, four expressions. What you have in "Description" is the expression label. And, check "Horizontal" on the Presentation tab.

Thu, 21 May 2015 03:07:26 GMT

Thanks! It works!

maxgro — Thu, 21 May 2015 07:17:57 GMT

please close this thread (mark useful and correct answer); thanks

MarcoWedel — Fri, 22 May 2015 23:24:26 GMT

also possible:

Pick(Match(Valuelist(value1,value2,value3),value1,value2,value3), expression1,expression2,expression3)

hope this helps

regards

Marco