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: 
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
Partner - Specialist III
Partner - Specialist III

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.