topic Re: Look at data by Quarters in Months in QlikView

Look at data by Quarters in Months

Mon, 29 Jun 2015 08:51:11 GMT

Just wondering if anybody could help me look at my data by Quarters for the year. The date format is as follows for example 31/12/2014 so I have figured out how to load the data in separately as Month and as Year separately which helps. But I was wondering if their is anyway I can break this down to be able to view the data quarterly also.

What I have is counting the number of companys signed up each month so I can see the data Monthly and Yearly but I am hoping to be able to see Quarterly aswell.

Attached is an example of the type of data I am using.

Re: Look at data by Quarters in Months

marcus_sommer — Mon, 29 Jun 2015 09:19:14 GMT

You could use an expression like this:

ceil(num(month(YourDateField)) / 3) as Quarter

- Marcus

Re: Look at data by Quarters in Months

vcanale — Mon, 29 Jun 2015 15:12:40 GMT

or
'Q' & ceil(num(month([YourDateField])),3) /3&'-'&right(year(YourDateField),4) as QQ-YYYY

Re: Look at data by Quarters in Months

Mon, 29 Jun 2015 15:39:03 GMT

Do I put this as an expression each time I create a chart?

Re: Look at data by Quarters in Months

ramoncova06 — Mon, 29 Jun 2015 15:50:20 GMT

no both options are for creating the field at script level, if you do not want to modify your script you can use either option without the " as Quarter/as QQ-YYYY" and yes you would have to add it to each chart

Re: Look at data by Quarters in Months

vcanale — Mon, 29 Jun 2015 15:54:47 GMT

If you need to see regularly the data by Quarters, I suggest to add this line

'Q' & ceil(num(month([YourDateField])),3) /3&'-'&right(year(YourDateField),4) as QQ-YYYY

in the script when/where you load YourDateField and you'll have 'QQ-YYYY' in your available fields.

Then you can use this field in a ListBox or in a MultiBox to filter the data by Quarters at any time and in any Object (Charts or also TableBox).

Re: Look at data by Quarters in Months

marcus_sommer — Mon, 29 Jun 2015 15:57:13 GMT

I would do it within a master-calendar: How to use - Master-Calendar and Date-Values

- Marcus

Re: Look at data by Quarters in Months

buzzy996 — Mon, 29 Jun 2015 16:27:54 GMT

PFA,