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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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

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

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