Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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