Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
sanjyotpatkar
Creator III
Creator 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
Specialist
Specialist

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!

View solution in original post

2 Replies
Sergey_Shuklin
Specialist
Specialist

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!

View solution in original post

sanjyotpatkar
Creator III
Creator III
Author

Thanks..It worked