topic Re: Default Page in QlikView

Default Page

Thu, 30 Apr 2015 21:14:55 GMT

Hi,

I have the 'years' 'Month' column with values,

when the user opens the page, i want The dashboard to display a Default year like '2014' or '2015'.

So that when they open the pae , the page is not slow because of script going through millions of rows.

Instead with the 'Default year' it only looks for that year rows, and thus the page response is faster.

Please help me how to achieve this.

Any inputs are appreciated.

Thanks

Re: Default Page

beck_bakytbek — Thu, 30 Apr 2015 21:21:12 GMT

Hi mis mag

what do you mean with "page"? Show your example so we can find solution for your problem

Beck

Re: Default Page

Thu, 30 Apr 2015 21:32:18 GMT

I am sorry if i have confused you, but what i mean is 'Year' is a List Box and year values are diplayed on the dashboard like this... 2015 2014 2013 2012 2011 till 1990..

Now when the user opens the dashboard, by default all the years records are processed thus slowing it down..

SO i want it to default to previous year like ''2014' when the user opens the dashboard.

Hope it will add some clarity.

Thanks

Re: Default Page

Anonymous — Thu, 30 Apr 2015 21:39:58 GMT

Sheet Properties---Triggers--OnActiveSheet--Edit Actions-- Add--Select in Field

Re: Default Page

beck_bakytbek — Thu, 30 Apr 2015 21:43:03 GMT

No problem, lets try together to find the solution for your Problem Mis Mag

so you can use following expression: like : Sum({$<Year={"20*"}>}your Values in Field)

i mean for example: Sum({$<Year={"20*"}>}Values) = so you have only years that beginn with 2015, 2014, 2013

or Sum({$<Year={">1990<2014,2015"}>}Values) = All Year from 1990 until 2014,2015

I hope that helps

Beck

Re: Default Page

beck_bakytbek — Thu, 30 Apr 2015 22:25:07 GMT

Hi Mis Mag

Did you solved your issue?

Beck

Re: Default Page

ToniKautto — Fri, 01 May 2015 00:43:49 GMT

In general, save your application in the state you want it to be opened. Save the selection you want to apply on opening the document.

One way to limit slow chart objects can be to enable a Calculation Condition on the object, see chart properties' General tab for the setting.This means that a criteria defined by you will have to be fulfilled before the chart is rendered. For example you could have a criteria that require a selection in the Year field, by for example =Count(Year)<3 which means there must be 2 or less possible years for the chart to calculated.

Re: Default Page

awhitfield — Fri, 01 May 2015 13:52:51 GMT

Hi Mis Mag,

You need to create an 'OnOpen; document Trigger, that makes a selection in the field 'Year', you could hard code in to use a specific year e.g 2014 OR use something like =(max(Year)-1) as the search string that you use

Andy

Re: Default Page

Anonymous — Fri, 01 May 2015 14:05:41 GMT

I'd rather use =year(ReloadTime())-1 to define the previous year, in case if there are years in future in the list.

Re: Default Page

awhitfield — Fri, 01 May 2015 14:13:10 GMT

Or even =Year(today())-1

Re: Default Page

Anonymous — Fri, 01 May 2015 14:32:23 GMT

In almost all cases it is the same, but sometimes it is not. I prefer to use the reload date as the definition of today