topic Re: Current Quarter Data in QlikView

Current Quarter Data

Wed, 25 Nov 2020 16:16:04 GMT

How can we calculate current quarter sales in qlikview?

Re: Current Quarter Data

Chanty4u — Tue, 14 Jun 2016 05:43:35 GMT

chk here

Re: Set expressions for current Quarter and Month sales.

Re: Current Quarter

Re: Current Quarter Data

Tue, 14 Jun 2016 06:43:08 GMT

It's not working.

I have a date field with date starting from Jan-2015 to Apr-2016, I need to pick last three month sales from this.

And also need to pick Last Quarter Sales?

Re: Current Quarter Data

sasikanth — Tue, 14 Jun 2016 06:46:25 GMT

Also

Try something like below

Load *,

IF(DayNumberOfQuarter(Date_field)<=DayNumberOfQuarter(Today()),1,0) as QTD_Flag

From .... Table;

and use this flag in Set Analysis

Sum({<QTD_Flag={'1'}>}sales) --> will give you current quarter to date sales

Thanks

Sasi

Re: Current Quarter Data

tresB — Tue, 14 Jun 2016 06:49:09 GMT

Try to share a qvw with sample data and explain your requirement against that, so that we can work on right data and for right requirement without having to have much guess work.

QlikCommunity Tip: How to get answers to your post?

Re: Current Quarter Data

Tue, 14 Jun 2016 06:56:37 GMT

Below is the sample data:

I want the output to be as Current Three Month Sales that is sum of Feb-16, Mar-16 and Apr-16

and Current quarter Sales that is Jan-16, Feb-16, Mar-16

Date	Sales
Jan-15	75
Feb-15	77
Mar-15	59
Apr-15	70
May-15	91
Jun-15	51
Jul-15	99
Aug-15	58
Sep-15	82
Oct-15	94
Nov-15	82
Dec-15	66
Jan-16	66
Feb-16	56
Mar-16	68
Apr-16	81

Re: Current Quarter Data

akshayjain90 — Tue, 14 Jun 2016 07:43:03 GMT

Hi,

Refer this expression -

sum({<Date = {'>$(=(date(AddMonths( date#(max(Date),'DD/MM/YYYY'),-3),'DD/MM/YYYY')))'}>}Sales)

Regards,

Akshay

Re: Current Quarter Data

Kushal_Chawda — Tue, 14 Jun 2016 07:46:44 GMT

Try this

Assuming you date format is 'DD-MM-YYYY'

=Sum({<Date = {">=$(=Date(Quarterstart(max(Date)),'DD-MM-YYYY'))<=$(=date(max(Date),'DD-MM-YYYY'))"}>}Sales)

Re: Current Quarter Data

tresB — Tue, 14 Jun 2016 09:18:02 GMT

PFA

Re: Current Quarter Data

sasikanth — Tue, 14 Jun 2016 09:45:50 GMT

Try Below,

Date(date#(Date,'MMM-YY'), 'YYYYMM') as Month_year;

For Latest quarter

=sum({<Month_year={">=$(=date(QuarterStart(max(Month_year),-1),'YYYYMM'))<=$(=date( QuarterEnd(max(Month_year),-1),'YYYYMM'))"}>}Sales)

For last Three Months

=sum({<Month_year={">=$(=date(addmonths(max(Month_year),-2),'YYYYMM'))<= $(=date(addmonths(max(Month_year),0),'YYYYMM')) "}>}Sales)

Re: Current Quarter Data

Kushal_Chawda — Tue, 14 Jun 2016 10:00:05 GMT

try this

=Sum({<MonthYear= {">=$(=Date(Quarterstart(max(MonthYear)),'MMM-YY'))<=$(=date(max(MonthYear),'MMM-YY'))"}>}Sales)

Re: Current Quarter Data

Wed, 15 Jun 2016 04:12:26 GMT

Thanks Kushal, it worked.

But when I applied filter it showed me 0 for all the rows.

As per the below data, when I applied filter of Actaul_Goal then it returned me null value.

Date Actual_Goal Value

Jan-16 Actual 50

Feb-16 Actual 60

Mar-16 Actual 70

Apr-16 Actual 80

May-16 Goal 90

Jun-16 Goal 100