Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Cumlative Aggr Issue

Hi All ,

I have the below table with cumulative done and with below expression . 

Issue is when i click on Year Month values are changing . I tried to Agrr and nullify but seems nothing is happening .

Please find below when i Click 2019-Q4 numbers are changing .

Please help modify the expression . I'm okay to nullify also like when user click on Year or Month or YearQuarter table should be constant or have the same values when they click on Year Month

Table:

kiranpatil123_1-1587193823410.png        

Expression :

kiranpatil123_2-1587193990032.png

When i click 2019-Q4 ( values should not change but it is )

kiranpatil123_3-1587194219201.png

Advance Thanks

 

Labels (1)
1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Check the solution provided by @sunny_talwar on below post.

https://community.qlik.com/t5/New-to-QlikView/Get-Cumulative-sum-upto-particular-time-selection/m-p/...

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Check the solution provided by @sunny_talwar on below post.

https://community.qlik.com/t5/New-to-QlikView/Get-Cumulative-sum-upto-particular-time-selection/m-p/...

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!