topic Re: Defalut quarter Issue in QlikView

Defalut quarter Issue

pavanqlik — Fri, 06 Apr 2018 07:42:18 GMT

Hi Folks,

I have 5 quarter in my data from 2017-Q4 to 2018-Q4.Right now im in 2018-Q2 .Now my requirement is as soon as i open dashbaord 2018-Q2 needs to be selected by default.

Could you please help me on this.

Thanks,

Pavan

Re: Defalut quarter Issue

Chanty4u — Fri, 06 Apr 2018 07:52:13 GMT

use document on open trigger

Re: Defalut quarter Issue

techvarun — Fri, 06 Apr 2018 07:53:31 GMT

Create a trigger onOpen document something like below

Re: Defalut quarter Issue

pavanqlik — Fri, 06 Apr 2018 07:59:15 GMT

if next quarter comes what we need to do

Re: Defalut quarter Issue

krishna789 — Fri, 06 Apr 2018 07:59:36 GMT

hi,

Has Chanty said go to settings ->sheet properties or document properties(According to requirement )->On active sheets edit->add select in field -> field =quarter and string =2018-Q2

Thanking you,

krishna

Re: Defalut quarter Issue

pavanqlik — Fri, 06 Apr 2018 08:01:51 GMT

If next Quarter comes

Re: Defalut quarter Issue

techvarun — Fri, 06 Apr 2018 08:11:11 GMT

In this case you have to Keep the latest Quarter in a variable.... you can set the variable in Load Script itself.

Derive the value from Calendar and store the value in a Variable.