topic Re: Expression in QlikView

Expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone!

I have one table like this:

I would like to calculate CA and DA columns based on this formula: CA=CQ*WA and DA=DA*WA and then present below table:

How can i do this?

bhaskar_sm — Wed, 09 May 2018 04:46:30 GMT

Hi,

Can you clarify this " DA=DA*WA" ?

Anonymous — Wed, 09 May 2018 04:51:34 GMT

sorry DA=DQ*WA

supriya10 — Wed, 09 May 2018 04:56:03 GMT

hello,

If you are using Straight Table, Item Number is your dimension and all other are your Measures,

then label each Measures and use which field you want in calculation with their labels

vishalarote — Wed, 09 May 2018 04:58:24 GMT

In DA * WA Initially DA is Null if you multiply with null value with WA it becomes null.

So What is DA in your expression?

bhaskar_sm — Wed, 09 May 2018 05:12:43 GMT

Hi,

please find attached the Qvd. you can calculate this in Bakend using script and front end as well ..

if you found this helpful, please mark helpful or correct.

regards,

Bhasker