topic Expression Error in QlikView

Expression Error

Thu, 24 Nov 2011 08:08:44 GMT

Hi Experts,

I m getting the wrong sum of amount and quantity when i use the following expression

sum([Billing Sales Quantity_FKIMG])

Sum ( [Billing Sales Amount_NETWR])

I have attached a image of my pivot table for ur reference

The correct amount is given as dimension for your reference.

Actually in the expression, the values are getting doubled..

Is my expression is right??

or Any suggestions why the values are getting doubled??

Please help me out... Its ver urgent.

Thanks,

Gaayathri

Expression Error

Thu, 24 Nov 2011 08:36:26 GMT

I think that the expression is right. I think that your problem is in the data model. The Sum expression is generating duplicated the values, because the data was duplicated in the data model, and it differs in a dimension that you are not showing in the table. It usually happend when you do any type of table join in the load script.

Expression Error

Thu, 24 Nov 2011 09:39:29 GMT

Hi Claudio,

I have tried eliminating duplication in data model. But still it doesn't works for me!! Can u please suggest me the posibility for the occurance of data??

Cheers,

Gaayathri

Re: Expression Error

SunilChauhan — Thu, 24 Nov 2011 09:49:09 GMT

i hope u need to do the following

convert pivot into straight table

gott properties-> expression-> select expression one by one and check the radio Noofrows inplace of Expression total

and then convert into pivot table.

hope this help

other wise attach sample file if u can.

Expression Error

Thu, 24 Nov 2011 09:59:51 GMT

Hi sunil,

I tried doing it but it doesnt work... I cannot provide u the file as it is abt 100MB

thanks,

Gaayathri

Expression Error

Thu, 24 Nov 2011 10:02:05 GMT

Hi,

I have faced the same issue some time back. It is due to doublin of records while performing left or right joins. One thing we can do is, create another table with the Primary key fields and the Amount fields. Then try the same expressions in the chart.

Hope it will help.

Expression Error

SunilChauhan — Thu, 24 Nov 2011 10:09:02 GMT

you can also try following

sum(Total <primary keyfield>[Billing Sales Quantity_FKIMG])

Sum ( Total <primary keyfield> [Billing Sales Amount_NETWR])

hope this help