topic Re: Default selection in QlikView

Default selection

Mahamed_Qlik — Fri, 17 Jun 2016 07:21:04 GMT

Hi All,

On opening the document, I want to show the last two years to be selected as default.

I do have field named as Year.

Year

2012

2013

2014

2015

2016

So, when opening the document I want 2016 and 2015 should be selected.

Please advise.

Regards,

Mahamed

Re: Default selection

Anonymous — Fri, 17 Jun 2016 07:25:05 GMT

Hi mahamed,

1.- Create a variable like this: vEntrySelections = '('&Max({1}Year)&'|'&Max({1}Year)-1&')'

2.- On Document Properties -> Triggers -> Document Triggers -> On Open:

Field -> Year

Search String -> =$(vEntrySelections)

Regards!!!

Re: Default selection

avinashelite — Fri, 17 Jun 2016 07:30:27 GMT

Try like this :

Go to >Document properties > Triggers > On Open Trigger >select in Field

Select the Year field and write this expression

'('&Max(Year,1) &'|'&Max(Year,2)&')'

Re: Default selection

Fri, 17 Jun 2016 08:10:25 GMT

Create a trigger ,

Select the Year field

expression

='>=$(Variable1)'

where Variable1=max(Year)-1

Thanks

Khushboo

Re: Default selection

Mahamed_Qlik — Fri, 17 Jun 2016 08:41:03 GMT

Hi Khushboo.

Thank you for your kind response. But using your expression will give me only single year data.

You are using the Variable1=max(Year)-1 ie. the variable will store only max year -1

for example my max year is 2016 then your variable will store 2015 and on opening it will show single year only.

But, appreciate again for your kind response.

Regards,

Mahamed

Re: Default selection

sasikanth — Fri, 17 Jun 2016 08:58:56 GMT

HI, Mohamed

You might not understand the

expression

='>=$(Variable1)'

The above expression select all the values which are greater than the given value

here given value i.e. Variable1=max(Year)-1 = 2015 , so it will select 2016 and 2015 both

you can write the expresion directly

Re: Default selection

avinashelite — Fri, 17 Jun 2016 10:35:31 GMT

Did you tried my suggestion

Go to >Document properties > Triggers > On Open Trigger >select in Field

Select the Year field and write this expression

'('&Max(Year,1) &'|'&Max(Year,2)&')'

Re: Default selection

Kushal_Chawda — Fri, 17 Jun 2016 10:41:20 GMT

Go to >Document properties > Triggers > On Open Trigger >select in Field

Select Year field and write below expression in Value

='(' & concat(distinct {<Year={">=$(=max(Year)-1)"}>} Chr(34) & Year & Chr(34),'|') & ')'

Re: Default selection

susovan — Fri, 17 Jun 2016 11:07:37 GMT

Hi mahamed,

Try this Way

Go to >Document properties > Triggers > On Open Trigger >select in Field

Field : " Year "

Search String : " ='(' & (vYear1) & '|' & (vYear2) & ')' "

Here,

vYear1=Max(Year)

vYear2=Max(Year)-1