Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bhaveshp90
Contributor III

Need help with Expression

Hello, 

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

1.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

I am trying to create a pivot table as shown below

1.PNG

 

 

 

 

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)

1.PNG

 

 

 

 

 

 

 

 

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. 

 

1 Solution

Accepted Solutions

Re: Need help with Expression

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

4 Replies
pradosh_thakur
Honored Contributor II

Re: Need help with Expression

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.
Learning never stops.
bhaveshp90
Contributor III

Re: Need help with Expression

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

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

bhaveshp90
Contributor III

Re: Need help with Expression

you are awesome @sunny_talwar , thank you very much :smileyhappy: