topic viewing Q4 2010 and Q1 2011 in QlikView

viewing Q4 2010 and Q1 2011

Mon, 25 Jul 2011 06:19:58 GMT

currently i have year/quarter/month/week list boxes, i also have line/bar charts with cyclic group year/quarter/month/week...

lets say the user wanna look data over Q4 2010 and Q1 2011, how can i go about doing it?

viewing Q4 2010 and Q1 2011

Mon, 25 Jul 2011 09:10:09 GMT

Hi,

view QuarterName(date).

This function returns a display value showing the months of the quarter and year.

viewing Q4 2010 and Q1 2011

Tue, 26 Jul 2011 00:25:54 GMT

how i do use this "view QuarterName(date)" exactly?

currently when i select Q4, Q1, 2011, 2010 from list boxes, i will be seeing Q4 and Q1 on the charts

however, the Q4 i see on the chart will be the result of Q4 of 2011 with Q4 of 2010 and the Q1 i see on the chart will be the result of Q1 of 2011 with Q1 of 2010...

how can i not see them aggregating the data together like that? instead, could i see this on the bar chart:

Bar-Of-Q4-2010 Bar-Of-Q1-2011

------------------------------------------------

Q4 2010 Q1 2011

hope the description of my requirements is clearer now... thanks!

viewing Q4 2010 and Q1 2011

Wed, 27 Jul 2011 02:21:50 GMT

hello guys, any idea how i could proceed?

viewing Q4 2010 and Q1 2011

rahulgupta — Wed, 27 Jul 2011 15:01:49 GMT

Hey Hi Axon,

You have to create a new Additional Field in the Script,

Load *,

Quarter&' '&Year as QuarterYear

From table;

Then you can use it any where.

Hope this solves your issue.

Regards

viewing Q4 2010 and Q1 2011

Thu, 28 Jul 2011 01:11:07 GMT

ahhhhh thanks Rahul! that did it

viewing Q4 2010 and Q1 2011

rahulgupta — Thu, 28 Jul 2011 06:02:31 GMT

my pleasure