Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression

Hi everyone!

I have one table like this:

    

itemnumberBeginning QuantityBeginning AmountWACQCADQDA
10051022 5
2002115.53 3
30031241

3

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:

    

itemnumberBeginning QuantityBeginning AmountWACQCADQDA
100510224510
2002115.5316.5316.5
3003124143

12

How can i do this?

5 Replies
bhaskar_sm
Partner - Creator III
Partner - Creator III

Hi,

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

Anonymous
Not applicable
Author

sorry DA=DQ*WA

supriya10
Partner - Contributor III
Partner - Contributor III

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 labelsa.png

vishalarote
Partner - Creator II
Partner - Creator II

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
Partner - Creator III
Partner - Creator III

Hi,

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

tesst.PNG

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

regards,

Bhasker