topic Re: How to write this expression in Qlik? in App Development

How to write this expression in Qlik?

Mon, 04 Jul 2016 19:44:04 GMT

do you know how can i write in qlik language this expresssion below. I'm still debutant in qlik . thank you

if(calendar1.Date=getcurrentselection(),calendar2.Date=(calendar2.Date<calendar1.Date))

Re: How to write this expression in Qlik?

arasantorule — Tue, 05 Jul 2016 03:31:57 GMT

Hi,

Can you briefly explain your requirement in words.

Thanks.

Re: How to write this expression in Qlik?

Tue, 05 Jul 2016 07:52:05 GMT

hello,

i have 2 dimensions calendar. calendar1 contain field date1, calendar2 contain field date2. i want when i select one date to date1(example 12/052016). In calendar2, it show me date which possible selected (date2<date1 possible selected)

example in date2 possible selected are (09/05/2016,10/05/2016,11/05/16).

thank you for your help

Re: How to write this expression in Qlik?

arasantorule — Tue, 05 Jul 2016 08:01:17 GMT

Hi,

Am I correct to say that, when you select the date "calendar1.Date", you want to show the previous dates in "calendar2.Date".

Do you have 2 calendars in the Application and if so, are they linked to each other?

Thanks.

Re: How to write this expression in Qlik?

Tue, 05 Jul 2016 09:16:21 GMT

yes i have 2 calendar in my application , the information are the same. link between calendar1 and calendar2 is field date

calendar1:

Load

TempDate AS date1,

TempDate AS date,

week(TempDate) As Week,

Year(TempDate) As Year,

Month(TempDate) As Month,

MonthName(TempDate) as MonthYear,

Day(TempDate) As Day,

ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,

Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,

WeekDay(TempDate) as WeekDay

Resident TempCalendar

Order By TempDate ASC;

Drop Table TempCalendar;

calendar2:

Load

TempDate AS date2,

TempDate AS date

Resident TempCalendar

Order By TempDate ASC;

Drop Table TempCalendar;

thank you for your help