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

Progressive selection

Hi,

I have to select all days from the First of the Year to today. I want that users click on button and selection is made. How can I do this?

5 Replies
MK_QSL
MVP
MVP

Add action to Button

Add

Selection

Select in Field

Field

Date

Search String

='>='&YearStart(Today()) & '<=' & Today()

sunny_talwar

You will need select in field action with the following Search String:

='>=' & Date(YearStart(Max(DateField)), 'YourDateFormat') & '<=' & Date(Max(DateField), 'YourDateFormat')

Not applicable
Author

Manish,

Your solution works. But I have another question:

I'm working mainly with years, months and weeks; how can I get the same action for these 3 fields?

MK_QSL
MVP
MVP

Can you elaborate little more on your requirements?

Not applicable
Author

Yes, here it is.

I want to see sales made between the First of the year and today, but I didn't loaded a Date field: instead, I've loaded 4 fields: year, month, week and day (monday, tuesday...).

Now, my purpose is to have a selection in each of this field. In other words, if I click this button, I get selection:

- 2015 in Year;

- from January to September in Month;

- from 1 to 37 in Week.

(days aren't a problem).