Discussion board where members can get started with QlikView.
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?
Can you clarify this " DA=DA*WA" ?
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
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?
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.