topic Re: YTD in QlikView

YTD

Mon, 06 Oct 2014 13:49:51 GMT

In my table month range is 01,02,03,04,05,..............

if I select 04,

how can i get YTD ? that means jan to apr value.

Re: YTD

mjayachandran — Mon, 06 Oct 2014 13:54:03 GMT

Check this

YTD until selected day

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd

Re: YTD

ashfaq_haseeb — Mon, 06 Oct 2014 13:58:23 GMT

Hi,

Check this

YTQ, QTD, MTD and WTD

Regards

ASHFAQ

Re: YTD

Mon, 06 Oct 2014 14:14:15 GMT

hi Ashfaq,

i can't identify solution from this. please post me an example.

thx

Rgds

Chandana

Re: YTD

ashfaq_haseeb — Mon, 06 Oct 2014 14:17:56 GMT

One of the good example from Manish Kachhia

Consider that you have below dummy data….

Load 
Date(Date) as Date,
Month(Date) as Month,
'Q'&Ceil(Month(Date)/3) as Quarter,
Sales
Inline
[
Date,       Sales
01/01/2014, 100
10/01/2014, 1000
04/02/2014, 500
03/03/2014, 1200
15/03/2014, 130
25/03/2014, 200
01/04/2014, 180
21/04/2014, 300
15/05/2014, 200
20/05/2014, 100
11/06/2014, 400
12/07/2014, 220
20/07/2014, 450
01/08/2014, 600
15/08/2014, 200
17/08/2014, 220 
25/08/2014, 10000
];

SUM({<Date = , Month =, Quarter = >}Sales)
will give you Total Sales 16000

SUM({<Date = , Month =, Quarter = , Date = {">=$(=YearStart(Today()))<=$(=Today())"}>}Sales)
will give you Total Sales For Current Year to Date


SUM({<Date = , Month =, Quarter = , Date = {">=$(=MonthStart(Today()))<=$(=Today())"}>}Sales)
will give you Total Sales for Current Quarter to Date


SUM({<Date = , Month =, Quarter = ,Date = {">=$(=QuarterStart(Today()))<=$(=Today())"}>}Sales)
Will give you Total Sales For Current Month to Date

The above YTD, QTD and MTD irrespective of Date, Month and Quarter selection as these fields are already bypassed…

Quoted from HERE

Regards

ASHFAQ

Re: YTD

Mon, 06 Oct 2014 14:33:27 GMT

For my example , I have month like 1,2,3,4,5,6,7,8,9,10,11,12

Then how can I do this

Re: YTD

ashfaq_haseeb — Mon, 06 Oct 2014 14:35:16 GMT

Concept will be same.

You just need to fine week code

Regards

ASHFAQ

Re: YTD

Mon, 06 Oct 2014 14:42:37 GMT

thx

Re: YTD

ashfaq_haseeb — Mon, 06 Oct 2014 14:44:20 GMT

Hi,

Can you close this thread by selecting appropriate answers

Regards

ASHFAQ

Re: YTD

martynlloyd — Mon, 06 Oct 2014 14:47:42 GMT

Hi, you could construct an expression using Yearstart(), Getfieldsselections() and Max() functions.

But I'm sure best practice would be to teach your users how to select a range...

regards,

Re: YTD

Tue, 07 Oct 2014 07:32:42 GMT

Dear Ashfaq,

Following command is working. But I need to get YTD for selected month i.e. up to May.

SUM({}Sales)

Re: YTD

ashfaq_haseeb — Tue, 07 Oct 2014 07:37:29 GMT

Hi,

Check the post which I attached earlier.

YTQ, QTD, MTD and WTD

Regards

ASHFAQ