topic Need help with Expression in QlikView

Need help with Expression

bhaveshp90 — Sat, 16 Nov 2024 04:26:56 GMT

Hello,

I have a table with correct YTD and MTD values shown below;

I am trying to create a pivot table as shown below

So, When I removed Month and Project Number from my original table the YTD and MTD values are changed? I tried multiple ways to fix this but I didn't get the correct values as my original table. (as shown below)

What should I change in my YTD and MTD expression so that I can avoid Project Number and Month in the pivot table? Attached is the file for reference.

thanks

Bhavesh.

Re: Need help with Expression

pradosh_thakur — Thu, 14 Feb 2019 15:21:43 GMT

from the screenshot it seems like it is showing the correct total . The green in country column in the first tab shows you have china selected .So the YTD and MTD are matching those of china.I see nothing wrong here unless i am missing something obvious.

Re: Need help with Expression

bhaveshp90 — Thu, 14 Feb 2019 15:23:53 GMT

The second image is Excel sample data that I'm trying to get it. I've update my question now, please refer above

Re: Need help with Expression

sunny_talwar — Thu, 14 Feb 2019 15:28:32 GMT

If you are using QV12 or above.. try the attached

Re: Need help with Expression

bhaveshp90 — Thu, 14 Feb 2019 15:37:30 GMT

you are awesome @sunny_talwar , thank you very much