Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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
MVP
MVP

Re: getCurrentselection et set analysis

Try this instead

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

Not applicable

Re: getCurrentselection et set analysis

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

MVP
MVP

Re: getCurrentselection et set analysis

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

Re: getCurrentselection et set analysis

capqlik.JPG

Not applicable

Re: getCurrentselection et set analysis

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

MVP
MVP

Re: getCurrentselection et set analysis

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.