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: 
Not applicable

Need Help on Selecting Month as default selection

Hi Team,

Hope all re doing good....!

I need help on selecting the month which has recent data as a default selection while opening the application.

For Ex: i have year filed 2015 and in 2015 i have data till may only.

so when i opened my application by default it has to show may.

my month filed has month names not numbers.

i tried Max(month) in document triggers but its not working.

Please help on this.....

Thanks in advance...

Nani.

22 Replies
jagan
Partner - Champion III
Partner - Champion III

Not sure, generally that function works based on string not date.

Not applicable
Author

Yeah Jagan it is fetching the maximum string in associated values.

gautik92
Specialist III
Specialist III

you can use inline table

Months:

Mapping LOAD * Inline

[months, monthNo.

JAN, 1

FEB, 2

MAR, 3

APR, 4

MAY, 5

JUn, 6

JUL, 7

AUG, 8

SEP, 9

OCT, 10

NOV, 11

DEC, 12

];

ApplyMap('Months', Month), 1) as transactiondate,

then you can take Max(Month)