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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Thabang231
Contributor III
Contributor III

Creating variables

Good day 

I would like assistance here, I want to create a variable to only pick this current FY the field contain F2022, F2023, F2024, 

i want a variable to only pick the F2024 which is current.

Thanks

 

Labels (1)
1 Solution

Accepted Solutions
marksouzacosta
MVP
MVP

You can create a variable with the definition below. Note it will ignore any selection you made in your User Interface:

marksouzacosta_2-1719346901359.png

 

=MaxString({1} FiscalPeriod)

 

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

View solution in original post

1 Reply
marksouzacosta
MVP
MVP

You can create a variable with the definition below. Note it will ignore any selection you made in your User Interface:

marksouzacosta_2-1719346901359.png

 

=MaxString({1} FiscalPeriod)

 

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com