topic Re: Progressive selection in QlikView

Progressive selection

Mon, 14 Sep 2015 12:08:39 GMT

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?

Re: Progressive selection

MK_QSL — Mon, 14 Sep 2015 12:25:12 GMT

Add action to Button

Add

Selection

Select in Field

Field

Date

Search String

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

Re: Progressive selection

sunny_talwar — Mon, 14 Sep 2015 12:26:57 GMT

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

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

Re: Progressive selection

Mon, 14 Sep 2015 12:36:27 GMT

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?

Re: Progressive selection

MK_QSL — Mon, 14 Sep 2015 12:38:39 GMT

Can you elaborate little more on your requirements?

Re: Progressive selection

Mon, 14 Sep 2015 12:44:39 GMT

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).