Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
User0
Contributor III
Contributor III

Create a variable to store month value from the filter

Hi,
I want to have a month variable, which by default should store the current month num (example - Jul) but if there is a different month value selected from the filter pane then the variable should show that value (example - May)

please help.
Thankyou

Labels (4)
3 Replies
sidhiq91
Specialist II
Specialist II

@User0  Please see below expression.

=if(isnull(GetCurrentSelections()),Date(AddMonths(Today(),0),'MMM'),GetFieldSelections(Month))

If this resolves your issue, please like and accept it as a solution.

User0
Contributor III
Contributor III
Author

it did not work for me

sidhiq91
Specialist II
Specialist II

@User0  Could you please provide some sample data on it and let me try to help you on it