topic Error in calculating expression in QlikView

Error in calculating expression

bhaveshp90 — Sat, 16 Nov 2024 04:50:06 GMT

Hello,

I have a table below as shown below. I have my expression for OEC - Current as

=If(Num_Month = '$(vPreYearLastMonth)' and Year = '$(vPreYear)', 0, Sum(Updated_OEC_Budget))

Sum(Updated_OEC_Budget) = 179922+522900 = 702822; but the expression is wrong.

What is wrong here? Any help is greatly appreciated. I have attached qvw for reference;

Re: Error in calculating expression

sunny_talwar — Mon, 07 Jan 2019 19:43:50 GMT

The calculation is getting duplicated

Re: Error in calculating expression

bhaveshp90 — Mon, 07 Jan 2019 19:56:26 GMT

@sunny_talwar Is this something in the script that needs to be fixed. I have used the solution which you gave before (Link Table and concatenating). Can you tell me how to fix this issue?

thanks

Bhavesh

Re: Error in calculating expression

bhaveshp90 — Mon, 07 Jan 2019 19:57:47 GMT

@sunny_talwar what you said is correct, it is duplicating look at the image below; Cost_Code '3' and '4' has the same Engineering_Area

Re: Error in calculating expression

sunny_talwar — Mon, 07 Jan 2019 20:17:03 GMT

I am not sure in which step of the process are you duplicating your rows, but this is def. not happening while creating the link table.... this has to be happening before or after... I am not sure how I can pin point this without being able to reload.. can you share all the qvds needed to reload this dashboard?

Re: Error in calculating expression

bhaveshp90 — Mon, 07 Jan 2019 20:36:25 GMT

thank you @sunny_talwar, Please use the below links for the qvd files

https://drive.google.com/file/d/1PFbl4J_ypPkSzvZTBogUE0EzMQraldZC/view?usp=sharing

https://drive.google.com/file/d/14tEX6nnaddzxb3IgyYNJu7OqykaQQWSc/view?usp=sharing

-Bhavesh

Re: Error in calculating expression

sunny_talwar — Mon, 07 Jan 2019 20:41:20 GMT

Unfortunately, I cannot access google drive. Are you not able to attach the qvd directly here?

Re: Error in calculating expression

bhaveshp90 — Mon, 07 Jan 2019 20:44:07 GMT

I'm getting an error (The contents of the attachment doesn't match its file type) when I attach qvd files here. Is there any other way I can attach the qvd?

Re: Error in calculating expression

sunny_talwar — Mon, 07 Jan 2019 20:49:23 GMT

Try to zip them before you attach

Re: Error in calculating expression

bhaveshp90 — Mon, 07 Jan 2019 20:53:47 GMT

thank you @sunny_talwar, I have attached the qvd now in the zip file.

Re: Error in calculating expression

bhaveshp90 — Tue, 08 Jan 2019 15:34:20 GMT

Hi @sunny_talwar, did you able to find the qvd files attached?