Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikcheepirishe
Creator
Creator

On list-box selection of month I want all the previous month to be selected

I have field Month I used it in list box.

My requirement is that when I click march so it should select January and february as well

basic is to whichever month I select I wanted to get selected all the previous month in listbox

7 Replies
sunny_talwar

Check attached

qlikcheepirishe
Creator
Creator
Author

can you please explain me the basic script behind this logic

sunny_talwar

I used a select in field based on the selection in Month field....

Field

Month

Search String

='<=' & Max(Month)

MarcoWedel

maybe helpful:

The As-Of Table

regards

Marco

qlikcheepirishe
Creator
Creator
Author

can you please elaborate I didn't get it

sunny_talwar

May be it will be better if you can share a sample to show the kind of data you have and what exactly are you trying to do in your specific case

qlikcheepirishe
Creator
Creator
Author

I want to show previous month data when the user click on one of the month

for ex: If the user clicks on May month then it show default select all the previous month April,March, february, january like this. So, it will display all previous data