Need help in Expression

Sun, 01 Apr 2012 07:20:30 GMT

Hello,

Can any one help me in Expressions,i am facing some problem in creating expressions,the values is displaying in pivot chart but it is not matching with database values.

I want to display the expressions for:

1)standard quantity for actual production

for this one i used expression is ''SUM({<Complete={'Y'}>} (QtyManufactured*UnitQtyReqd))''

2)Actual Quantity issued

for this one i used expression is ''SUM(QtyManufactured*UnitQtyReqd)- QtyIssued''

3)Quantity variance

for this one i used expression is ''SUM({<Complete={'Y'}>} (QtyManufactured*UnitCost*UnitQtyReqd))''

4)standard cost for actual production

for this one i used expression is ''SUM({<Complete={'Y'}>} (QtyManufactured*UnitCost*UnitQtyReqd))''

5)actual cost

for this one i used expression is ''SUM({<Complete={'Y'}>}(ValueIssued))''

6)cost variance

for this one i used expression is''SUM({<Complete={'Y'}>}(QtyManufactured*UnitCost*UnitQtyReqd-ValueIssued))''

i am having these fields,QtyManufactured,UnitCost,UnitQtyReqd,ValueIssued,QtyIssued,etc..

Regards,

Need help in Expression

jagannalla — Sun, 01 Apr 2012 10:33:29 GMT

Can you attach any same file and display the data in table and show what result you want in any image format or excel format according to your data here.

topic Need help in Expression in QlikView

Need help in Expression

Need help in Expression