topic Default to Current Year in QlikView

Default to Current Year

Wed, 16 Nov 2011 07:09:26 GMT

When sheet is activated, I want to default field "Year" to Current Year Variable.

Field = Year

Variable = _SySCurrentYear

Can someone suggest how to do this?

Re: Default to Current Year

its_anandrjs — Wed, 16 Nov 2011 07:28:55 GMT

Hi,

I suggest you do this like

Field = Year

Variable = Year(Yearstart( Today( ) ) )

Rgds

Anand

Re: Default to Current Year

its_anandrjs — Wed, 16 Nov 2011 07:33:48 GMT

Hi,

Or you can directly assign if there is field Year like

Field = Year

Variable = Year

Rgds

Anand

Default to Current Year

Wed, 16 Nov 2011 08:59:28 GMT

where should i assign this? i want this filter to be applied only for 1 chart on 1 sheet and not for rest of the sheets

Re: Default to Current Year

its_anandrjs — Wed, 16 Nov 2011 09:19:39 GMT

Hi,

Use this variable only on single sheet or single chart.

Rgds

Anand

Re: Default to Current Year

johnw — Thu, 17 Nov 2011 00:26:28 GMT

If you only want this to affect a single chart, you probably don't want to make any selections. Instead, you'll probably want set analysis. As an example, say your chart has an expression of sum(Sales). To restrict this to only the current year based on your variable, you might use an expression like this.

sum({<Year*={'$(_SySCurrentYear)'}>} Sales)

The exact expression may depend on how your field and variable are defined, though.