cyclic group - Use the same field but with different formats depending on the chart.

[#1]

I have a cyclic group with date fields.  This cyclic group has Year->YearMonth->Week->Date.

This cyclic group is being used in two charts, one chart being much larger than the other. In one chart we want the month to follow the MMM YY format. In the smaller chart we just want to grab the first letter of the Month.

How can I get this month field to have one format in one chart but a different format in another chart?

I'm avoiding the use of two separate cyclic groups because I want the charts to be in the same date group as I cycle through.

[manojkvrajan]

I wish if we have a solution to this which will save the repetitive cyclic groups. However, QlikView doesn't have this feature to my knowledge.

[Anonymous]

Limit Legend (characters) to 1 almost resolves this, but only for Months.  Not good when you switch to Year or Week...  So, here is the idea you can propose - allow to have "Limit Legend (Characters)" conditional.

Regards,

Michael

[sebastiandperei]

With hierarchy groups, the selection in one group will affect the other group.

In this case, Year, Year/Month, Week an Date is a correct order of hierarchy. When you select some particular Year, both groups will attend this selection, and will show you all Year/Month's related with this year. Then, you could modify the showing properties of each field in each group as different.

Try and tell me.