topic Getting Values Quarter wise in QlikView

Getting Values Quarter wise

Fri, 20 Mar 2015 04:55:46 GMT

Hello Everybody,

I am using the below fields in a Straight Table

Business Unit

Assured BA Code

Assured Name

Assured Country

Forecast New Existing Non Recurring

Forecast New Existing Recurring

Forecast New New Non Recurring

Forecast New New Recurring

Forecast Non Recurring

ForecastRATE

By using the below expression am getting the individual records.

Expression:

[Forecast New Existing Non Recurring]+[Forecast New Existing Recurring]+[Forecast New New Non Recurring]+[Forecast New New Recurring]/ForecastRATE

Now I want to group it up the values and get values quarter wise as shown in the attached file.

Could anyone please advise how to achieve this.

Thanks In Advance

Ashish

amit_saini — Fri, 20 Mar 2015 05:08:12 GMT

Ashish,

You don't have any date field here , you need include the same and further follow script for calculating data Q wise :

	Date(Date, 'MM/DD/YYYY') as [Date Coded],
	Monthname(Date) as Month,
	Year(Date) as Year,
	Quartername(Date) as Quarter,
	'Week'&Ceil(Day(Date)/7) as Week,

Thanks,

Fri, 20 Mar 2015 05:12:48 GMT

Hi Amit,

Thanks for the reply.

I have a date field but didn't use here. Will include the field and give a try.

Thanks

Ashish

amit_saini — Fri, 20 Mar 2015 05:16:10 GMT

Hi Ashish,

Good , after doing this call Quarter as dimension and your expression below to see the desired result:

[Forecast New Existing Non Recurring]+[Forecast New Existing Recurring]+[Forecast New New Non Recurring]+[Forecast New New Recurring]/ForecastRATE

Hope this will help you!

Thanks,