Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

viewing Q4 2010 and Q1 2011

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?

1 Solution

Accepted Solutions
rahulgupta
Partner - Creator III
Partner - Creator III

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

View solution in original post

6 Replies
Not applicable
Author

Hi,

view QuarterName(date).

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

Not applicable
Author

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!

Not applicable
Author

hello guys, any idea how i could proceed?

rahulgupta
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

ahhhhh thanks Rahul! that did it

rahulgupta
Partner - Creator III
Partner - Creator III

my pleasure