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

Getting Values Quarter wise

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

3 Replies
amit_saini
Master III
Master III

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,

AS

Not applicable
Author

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
Master III
Master III

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,

AS