topic Toggle between Day and Month Dimensions in QlikView

Toggle between Day and Month Dimensions

Thu, 09 Feb 2012 19:02:45 GMT

I have this basic pivot table. http://screencast.com/t/yf7BqnoQ9p. Right now it is cut by day but users want all of these reports to quickly toggle by day or month. I can add month but then we have to expand again by day. I don't really want to copy all the reports and change the day to a month. Any ideas on how to do this easily?

Toggle between Day and Month Dimensions

pover — Fri, 10 Feb 2012 05:47:10 GMT

You could use a cyclical dimension group that contains day and month.

Karl

Toggle between Day and Month Dimensions

jagan — Fri, 10 Feb 2012 06:29:13 GMT

Hi,

You can use Cyclic Group as Dimension that contains Day and Month Fields. By using Cyclic group you can change the Dimension on clicking the Cyclic Group icon.

If you want to drill through from Month to Day(Days with in the selected Month) then you can use the Drill down group.

Regards,

Jagan.

Toggle between Day and Month Dimensions

Fri, 10 Feb 2012 16:29:06 GMT

I have done the expressions where I tick the relative and then group them. Then the little arrow shows up where I can rotate through. But how do I do that for dimensions?

Toggle between Day and Month Dimensions

pover — Fri, 10 Feb 2012 16:42:15 GMT

Go to the Properties window of the object. In the Dimensions tab, click on the "Edit Groups..." button and then click "New". Name the dimension group and add the dimensions you want included in the group. Once you've created the group and click 'OK' a couple times, don't forget to add the group to the object dimensions.

Karl

Toggle between Day and Month Dimensions

Fri, 10 Feb 2012 17:49:16 GMT

That did it. What a cool feature. My analysts are going to love this.