Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

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
Highlighted
Partner
Partner

Re: Expression

Hi,

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

Highlighted
Contributor

Re: Expression

sorry DA=DQ*WA

Partner
Partner

Re: Expression

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

Highlighted
Partner
Partner

Re: Expression

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?

Highlighted
Partner
Partner

Re: Expression

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