Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Finding Max Week value on Selection of Month and Year for Specific Dimension value

Hi All,

I have requirement where i should be able to pick only the maximum weeks values on selection of a month/Year and only on one dimension field value in the chart.

I have explained it below,

Please help me in achieving it through the script or in front end. I mostly prefer it in the backend.


I have also attached the sample file with data.


4 Replies

For Current Month (Feb), how are you getting Butter and Cookie = 120, but Milk = 40? Milk is related to Week 3 value, but Butter and Cookies are sum of Week 1, 2, and 3?

Contributor II
Contributor II

Yes, Milk should take only the Max week value of selected month(i.e week3 and value is 40), whereas butter and cookie should give sum of all three weeks that is 120

Specialist II
Specialist II

Maybe something like the below 



Kishore, did Qliksus' latest response get you what you needed?  If so, please be sure to return to the thread to close things out properly by using the Accept as Solution button on Qliksus' post, that will give them credit for the assistance and let other Members know it worked.  


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.