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

getCurrentselection et set analysis

hello,

i want to select date which  inferior  to getcurrentselection Date.

so i do  set analysis which don't work.

<date={"<$(=GetCurrentSelections(Date))"}>

6 Replies
sunny_talwar

Try this instead

{<date = {"$(='<' & Date(Max(date), 'DateFieldFormatHere'))"}>}

Not applicable
Author

i'm a error message

i inform you that field date different to field Date

i want  that i select one value in field date, i can see in field Date the values which inferior  to value selected in field date.

example

date 2/10/2010,3//10/2010,4/10/2010 ;

Date 2/10/2010,3//10/2010,4/10/2010

when i selected  4/10/2010 in date; in Date, the possible value are 2/10/2010,3//10/2010

thank you

sunny_talwar

There are two approaches which you can try...

{<DateField1 = {"$(='<' & Date(Max(DateField2), 'DateFieldFormatHere'))"}>}

or

{<DateField1 = p(DateField2)>}

1st option would show all the rows where DateField1 is less than the Max(DateField2) selected.

2nd option would show all those rows where DateField1 equals one of the DateField2 selected.

Note: DateField2 is the Date field where you will be making selection and is not linked to DateField1

Not applicable
Author

capqlik.JPG

Not applicable
Author

i prefer 1rst approch

{<Date1= {"$(='<' & Date(Max(Date2), 'dd/mm/yyyy'))"}>}

but i'm error  when i want to look.look at screnshot.thank you

sunny_talwar

Hahahaha

I think you just used the set expression part here. Where is the aggregation here? You need to use it like this:

Sum({<Date1= {"$(='<' & Date(Max(Date2), 'dd/mm/yyyy'))"}>}FieldName)

and continue to use Date1 as your dimension.