Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Madhab77
Contributor III
Contributor III

Default selection for Month and Year which are in a list object

Hi All 

I have a requirement to have default values for the Month and Year selection, the default value will come from a variable (LastReload date, and this date will come from file). The Year and Month selection fields are placed in a List object as follows:

Madhab77_0-1670420013982.png

I tried with initial Selection, it worked for Year field but not for Month field (as in the screenshot above).

If this requirement can be done with the bookmark, that will also work.

Please help to resolve my issue.

 

Thanks & Regards,

Madhab Sikder

Labels (2)
7 Replies
agigliotti
Partner - Champion
Partner - Champion

Hi @Madhab77 ,

What's the content of vBookmarkMonth variable?
What's the expected result for month initial selection?

Madhab77
Contributor III
Contributor III
Author

Hi agigliotti,

vBookmarkMonth will have Values like 'Jan', 'Feb', 'Mar'..... and Year will have values like 2020, 2021, 2022.....

Thanks & Regards,

Madhab Sikder

agigliotti
Partner - Champion
Partner - Champion

Let's try using numeric values ex. '1','2','3' for months.

Madhab77
Contributor III
Contributor III
Author

If you are saying vBookmarkMonth should contain 1, 2,3,....12, I tried with these, it did not work, may be because of Month field having values as 'Jan', 'Feb'..... And I can not change the values of the Month to 1,2,3..... as the client wants the Month should be 'Jan', 'Feb'....

agigliotti
Partner - Champion
Partner - Champion

Did you also try to put 1,2,3  or Jan,Feb,Mar in the Initial Selection textbox without using the variable ?

Madhab77
Contributor III
Contributor III
Author

if I provide =Month='Feb' in the search field of the selection it works fine.

 

agigliotti
Partner - Champion
Partner - Champion

Could you post a sample app with mock data to look at?