Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
venky77777
Contributor III
Contributor III

Not getting default selection as max month after using clear all button

Hi,

Applied 'Always select one value' option for S_MONTH field, but now when I click on 'clear all' button, I want to display max month in current year. 

venky77777_0-1722264083613.png

Applied actions for 'clear all' button as below image, but not showing current month only showing recent selected month as above (max month to show July)

venky77777_1-1722264243732.png

Can any one suggest, where I'm doing wrong. thanks in advance.

 

 

 

Labels (6)
1 Solution

Accepted Solutions
lennart_mo
Creator II
Creator II

I think the only problem that may occur with this, is that disregards the selected year, I'm guessing @venky77777 wants the max(month) in the actual year.

So I would suggest using Max({1<S_Year={"$(=Max(S_Year))"}>}S_Month)

View solution in original post

6 Replies
Or
MVP
MVP

Max(Month) is always going to be the selected month, because, well, it's selected.You could try using Max({1} Month).

steeefan
Luminary
Luminary

Try using MaxString(Month) in case your Month values are strings.

lennart_mo
Creator II
Creator II

I think the only problem that may occur with this, is that disregards the selected year, I'm guessing @venky77777 wants the max(month) in the actual year.

So I would suggest using Max({1<S_Year={"$(=Max(S_Year))"}>}S_Month)

venky77777
Contributor III
Contributor III
Author

Hi @Or 

Thanks for your reply. I tried Max({1} Month), but it is taking December and showing previous year data. As current year I have data till Sep 2024.

venky77777_0-1722267135685.png   

venky77777_1-1722267166886.png

 

 

venky77777
Contributor III
Contributor III
Author

Hi @steeefan ,

thanks for the reply, the same result when I try to use maxstring().

 

venky77777
Contributor III
Contributor III
Author

Hi @lennart_mo  ,

Thanks for reply, it works after adding {1} inside max(S_Year), i.e.

Max({1<S_Year={"$(=Max({1}S_Year))"}>}S_Month).

 

thanks every one.