-
Re: Need help to calculate YTD in Qliksense Pivot
Henri Eskelinen Aug 16, 2016 3:27 AM (in response to Gnanasekaran K)Please share the script that you use to load this data into Qlik Sense
-
Re: Need help to calculate YTD in Qliksense Pivot
Gnanasekaran K Aug 16, 2016 7:59 AM (in response to Henri Eskelinen)Hi,
Here is the script that i am using,
Load *, Month(Month) as "Fiscal Month",
Monthname(Month) as "Month Year",
Num(Monthname(Month)) as "MonthNo",
Year(Month) as "Fiscal Year";
select [Geography], [Sub-Geo], [Team Leader], [Sales Owner],[Customer group],[Customer Name],
[Programs],[Project ID],[Project Description],[Business Unit],[Service Line],[Service Description],
[Service Category],[Revenue Category],[Type],[Month],[Currency],[Trxn Amount],[Trxn Rate],
[Amount (INR)],[Amount (USD)],[Amount (GBP)]
FROM "Sales".dbo."ModifiedRawDataExcel"
where Month<GETDATE();
-
Re: Need help to calculate YTD in Qliksense Pivot
Miguel Braga Aug 16, 2016 10:02 AM (in response to Gnanasekaran K)Hey there,
Is your Month field like a Date field? Can you please post what is the values of Month field?
Regards,
MB
-
Re: Need help to calculate YTD in Qliksense Pivot
Gnanasekaran K Aug 16, 2016 10:04 AM (in response to Miguel Braga)Yes it is a date field. The value may look like this,
2016-07-15 00:00:00.000
2016-07-16 00:00:00.000
2016-07-17 00:00:00.000
2016-07-18 00:00:00.000
-
-
-
-
Re: Need help to calculate YTD in Qliksense Pivot
arul settu Aug 16, 2016 3:29 AM (in response to Gnanasekaran K)can you post the script how do you calculating
-
Re: Need help to calculate YTD in Qliksense Pivot
Gnanasekaran K Aug 16, 2016 3:33 AM (in response to arul settu)Hi Arul,
I am just doing simple pivot here. Rows - Geography, columns Month-Year and SalesType and Measures - SUM(Amount).
-
Re: Need help to calculate YTD in Qliksense Pivot
Allu Allu Aug 16, 2016 10:20 AM (in response to Gnanasekaran K)Hi
If you looking for YTD for 'Month-year' and 'Amount' check this
**Provided your 'Month-year' field is in 'MMM-YYYY' format **
The following will give Sum of last three months to up-to-date..
Date(Addmonths(Max(MonthYear), -3)..........................three months ago
Date((Max(MonthYear))..................................................this month ( or maximum month)
=Sum({$ <MonthYear={"$(='>=' & Date(Addmonths(Max(Month-Year), -3), 'MMM-YYYY') & '<=' & Date((Max(Month-Year)), 'MMM-YYYY'))"}>} Amount )
-
-