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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn 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

Hi @Madhab77 ,

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
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

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
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

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
Madhab77
Contributor III
Contributor III
Author

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

 

agigliotti

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it