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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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