Defalut quarter Issue

[pavanqlik]

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

[Chanty4u]

use document on open trigger

[techvarun]

Create a trigger onOpen document something like below

[pavanqlik]

if next quarter comes what we need to do

[krishna789]

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

[pavanqlik]

If next Quarter comes

[techvarun]

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.