Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Need help in Expression

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,

ba

1 Reply
jagannalla
Valued Contributor III

Need help in Expression

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.

Community Browser