Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

List Box

Hi Guys,

As u can see i have atached a snap shot of the list box ,

My requirement is like if i clear it by defualt it should always get current year and current month selected .Can plz some one through some light on this ?

Detail:

now i have selcted 2014 year and month as jun

When i clear the dashboard it should select the current year and current month .

Thnaks

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution

Regards,

Jagan.

View solution in original post

18 Replies
arulsettu
Master III
Master III

hi

select current year from list box and go to properties enable always one selected value. same as for month 

smilingjohn
Specialist
Specialist
Author

Thanks for the reply Arul

i have already done this , but when i clear it will remain the same . My requirement is like which ever year and month i select after clearing it has to go to current year and current month

Thanks

mukesh24
Partner - Creator III
Partner - Creator III

Hi John,

Apply Field level Trigger or on Clear Button Add action Select in Field

arulsettu
Master III
Master III

try this

Go to Settings -> Document Properties -> Triggers

Select the “OnOpen” trigger and press “Add Action”

Add the Select in Field Trigger (section Selection)

Field: year

Search String: = max(year)

Not applicable

Create a CLEAR ALL button, and under Action:

  1. Add-->Selection-->Clear All
  2. Add-->Selection-->Select in Field then
    1. Field: FiscalYear, Search String= "Year(Today())"
  3. Add-->Selection-->Select in Field
    1. Field: FiscalMonth, Search string ="Month(Today())"

Just check your date formatting tallies with the output of the Year( & Month( results.

Not applicable

Hi John,

You can try to use Set Clear State functionality, for example.

smilingjohn
Specialist
Specialist
Author

HI Guys

I tried all the option suggested by u guys but its not working

When i clear still it remains on the same selected month and year

avinashelite

Hi John,

Add an action in the clear section as suggested by  graemebaxter

this will do, please let me know if it not serve your requirement

Not applicable

Is the object being populated by an expression as opposed to just field names ?