Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

Defalut quarter Issue

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

6 Replies
Highlighted
Esteemed Contributor III

Re: Defalut quarter Issue

use document on open trigger

Highlighted
Valued Contributor II

Re: Defalut quarter Issue

Create a trigger onOpen document something like below

Capture.PNG

Highlighted
New Contributor II

Re: Defalut quarter Issue

if next quarter comes what we need to do

Highlighted
Contributor

Re: Defalut quarter Issue

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

Highlighted
New Contributor II

Re: Defalut quarter Issue

If next Quarter comes

Highlighted
Valued Contributor II

Re: Defalut quarter Issue

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.