Discussion Board for collaboration related to QlikView App Development.
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.
use document on open trigger
Create a trigger onOpen document something like below
if next quarter comes what we need to do
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
If next Quarter comes
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.