topic Dividing the Year in QlikView

Dividing the Year

Tue, 21 Dec 2010 18:11:19 GMT

hello guys ... I'm having a little problem

I have "Months of the Year", and want to divide this year in three periods (three fields), the 1st (January to April, 1 ° - 4 °), 2nd (January through August 1 - 8 °) and 3rd (January through December, every months)

1st period = jan, feb, mar, apr

2nd period = jan, feb, mar, apr, may, jun, jul, ago

3rd period = jan, feb, mar, apr, may, jun, jul, ago, sep, oct, nov, dec

then I need to make three graphs, one with values only the first 4 months, the second with values of only 1st month until the 8th month and the third with every months.

can someone help me?

Dividing the Year

matt_crowther — Tue, 21 Dec 2010 18:35:36 GMT

Very quick and dirty front-end solution:

Use a calculated dimension:

Period 1: '=if(date([Month],'MM')<=04,[Month]) '

Period 2: '=if(date([Month],'MM')<=08,[Month]) '

Period 3: '=if(date([Month],'MM')<=12,[Month]) '

Suppress the dimension values where null and you should have the result required.

Hope that helps,

Matt - Visual Analytics Ltd

Dividing the Year

Tue, 21 Dec 2010 18:57:40 GMT

thank you ... was what I was seeking