Discussion Board for collaboration related to QlikView App Development.
I am using the below fields in a Straight Table
Assured BA Code
Forecast New Existing Non Recurring
Forecast New Existing Recurring
Forecast New New Non Recurring
Forecast New New Recurring
Forecast Non Recurring
By using the below expression am getting the individual records.
[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
You don't have any date field here , you need include the same and further follow script for calculating data Q wise :
Thanks for the reply.
I have a date field but didn't use here. Will include the field and give a try.
Good , after doing this call Quarter as dimension and your expression below to see the desired result:
Hope this will help you!