Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
sanjyotpatkar
Contributor III

Cyclic Group - predefined selection on load of QV document

I have a cyclic group created: Months & Weekstart.

On Load of QV document I need all the charts to have only Weekstart shown as a default view on the charts in the cyclic group.

Is there a way to set this using trigger in Document Properties for cyclic groups?

1 Solution

Accepted Solutions
Sergey_Shuklin
Valued Contributor

Re: Cyclic Group - predefined selection on load of QV document

Hello!

Do the followin' steps for solving such task:

Step 1. Create a cyclic group with two conditionable dimensions:

cyc_1.png

where vTest is a variable:

cyc_2.png

and there is another one variable as you can see.

Step 2. Create a trigger on Reload (I don't get clear enough what you mean "On Load" - it can be just Open or Reload action, so I choose OnPostReload trigger):

cyc_3.png

Step 3. Create a trigger on second variable vPickGroup:

cyc_4.png

After that (after Reload) you will get a start value for vTest variable equal 2 (it will drop cyclic dimension to "Week_Start" position), and this value will be increased each time you'll change a dimension in cyclic group "date_group". And this is the main reason why we use the mod() function in the Step 1.

This should help to get Week_Start dimension on charts each time the document is reloaded:

cyc_5.png

Hope it will help, and if it so, please close the thread by marking answer as correct or helpful. Thank you!

2 Replies
Sergey_Shuklin
Valued Contributor

Re: Cyclic Group - predefined selection on load of QV document

Hello!

Do the followin' steps for solving such task:

Step 1. Create a cyclic group with two conditionable dimensions:

cyc_1.png

where vTest is a variable:

cyc_2.png

and there is another one variable as you can see.

Step 2. Create a trigger on Reload (I don't get clear enough what you mean "On Load" - it can be just Open or Reload action, so I choose OnPostReload trigger):

cyc_3.png

Step 3. Create a trigger on second variable vPickGroup:

cyc_4.png

After that (after Reload) you will get a start value for vTest variable equal 2 (it will drop cyclic dimension to "Week_Start" position), and this value will be increased each time you'll change a dimension in cyclic group "date_group". And this is the main reason why we use the mod() function in the Step 1.

This should help to get Week_Start dimension on charts each time the document is reloaded:

cyc_5.png

Hope it will help, and if it so, please close the thread by marking answer as correct or helpful. Thank you!

sanjyotpatkar
Contributor III

Re: Cyclic Group - predefined selection on load of QV document

Thanks..It worked