topic Cycle groups and Triggers/Actions in QlikView

Cycle groups and Triggers/Actions

Fri, 15 Oct 2010 21:03:58 GMT

I've a cycle group called time with three fields (year, month and quarter). Field year = ( year 1, year 2, year 3), Field Quarter ( Q1, Q2, Q3,....Q12) and Field Month (M1, M2,.....M36). My document should open with four quarters selected by default in cycle group. Q1, Q2, Q3 and Q4 which is equal to year 1 and M1 to M12.

Ation I have here is ON OPEN DOCUMENT = SELECT FIELD -> Quarter -> VALUE -> Q1, Q2, Q3, Q4.

When I cycle from Quarter to Year; selection should shift to Year 1 (Green), and when I click the cycle to select month it should switch to M1 - M12 (Green). Irrespective of what you have selected in the previous selection the switch in cycle group should always be either year 1, Q1 - Q4 or M1 - M12 depending on what you have switched to.

What I mean is every cycle: Quarter, Year and Month should default to Q1-Q4, Year 1, and M1 to M12 respectively. I am not able to achieve this with actions.

Cycle groups and Triggers/Actions

pover — Mon, 18 Oct 2010 03:30:33 GMT

If you want all 3 fields to be green you have to make an action to select each of the 3 field on opening the document. Otherwise, if you select Q1,Q2,Q3,Q4, M1 - M12 will be in white because they are related values, but not selected.

Additionally, Q1,Q2,Q3,Q4 all exist in year 1, year 2 and year 3 so all years will also remain white unless you are selecting a Quarter/Year field or also select a year.

So, if all your data have a link to the date, your action of selecting Q1,Q2,Q3,Q4 on opening the document doesn't do anything. What do you want to achieve?

Regards.

Cycle groups and Triggers/Actions

Wed, 20 Oct 2010 00:17:44 GMT

My datamodel has table called timeperiod with fields quarter, 6-months and year.

Quarter, 6-Months, Year

Q1 6M1 Y1

Q2 6M1 Y1

Q3 6M2 Y1

Q4 6M2 Y1

Q5 6M3 Y2

Q6 6M3 Y2 etc..

So, when I say that document should open on first four quarters selected, QV loads the first year of study (irrespective of year). Now the problem is when I switch through cycle group (for e.g. quarter to year) QV loses the 4- quarter selection and user has to make a manual selection again(in this case Y1). So there was a data for a moment and its gone next moment because we just switched through cycle group.

Is there anyway I can hold/persist the previous selection made and have (Year-1) green when I switch from Quarter to year?