topic Re: List box set Analysis expression in QlikView

List box set Analysis expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a query that if i open my application by default current year, current month (starting from Jan till current month ) should be selected by default,Similarly i want day (starting from 1st till current day ) should be selected. I was able to manage current section using triggers but not the entire period. Please help for the same.

Re: List box set Analysis expression

jaumecf23 — Mon, 19 Feb 2018 08:52:43 GMT

You can use a trigger OnOpen. Use the Action "Select in field" with a formula like this :

='(' & concat(DISTINCT {<Day={"<=$(=max(Day))"}>} Day,'|') & ')'

Re: List box set Analysis expression

rubenmarin — Mon, 19 Feb 2018 09:06:10 GMT

Hi Saksham, month values can be tricky but you can try with:

Year: =Max(YearField)

Month: ='<=' & Max(MonthField)

Day: ='<=' & Max({<Date={$(=Max(Date))}>} DayField)

Looking for the day of the max date because Max(DayField) can return always '31' if january is always selected at start.

Re: List box set Analysis expression

Anonymous — Tue, 20 Feb 2018 01:29:46 GMT

Day and Year are working fine but not month. Please help

Re: List box set Analysis expression

ahmar811 — Tue, 20 Feb 2018 03:54:06 GMT

Hi Saksham,

For month use below expression :

if your month field is string format use below code :

Month: ='('&Concat({<Year={$(=max(Year))}>}Month,'*|*')&')'

if your month field is Month Date format use below code :

Month: ='<=' & Max({<Year={$(=max(YearField))}>}MonthField)

I hope this will work for you.

Regards

Ahmar

Re: List box set Analysis expression

Anonymous — Tue, 20 Feb 2018 04:38:51 GMT

Do i have to use this expression in triggers?

Re: List box set Analysis expression

ahmar811 — Tue, 20 Feb 2018 04:53:37 GMT

Yes

Use in trigger,select your month field and put

='('&Concat({<Year={$(=max(Year))}>}Month,'*|*')&')'

expression

Regards

Ahmar