topic Re: Find YTD in QlikView

Find YTD

tyagishaila — Thu, 11 Dec 2014 05:47:29 GMT

what is the script to get YTD (Year Till Date)

YTD 13-14

YTD 12-13 and so on

e.g As today is 11 Dec,

YTD 12-13 means (01 April 12) to (11 Dec 13)

YTD 13-14 means( 01 April 13) to (11 Dec 14)

pick data for this time interval

Re: Find YTD

its_anandrjs — Thu, 11 Dec 2014 06:11:31 GMT

Hi,

By the use of the Date field in your fact table use that field for get the YTD calculation

Ex:-

=Sum( {$<Date = {'>$(=Max((YearStart(Date)))) <=$(=Max(Today()))'}>} Metrics )

The above expression gives you from selected year start to till date data.

Regards

Anand

Re: Find YTD

arulsettu — Thu, 11 Dec 2014 06:17:07 GMT

check this

YTQ, QTD, MTD and WTD

Re: Find YTD

Thu, 11 Dec 2014 06:27:46 GMT

attached document can help you..

Re: Find YTD

tyagishaila — Thu, 11 Dec 2014 06:36:40 GMT

Where should I write this expression,

in expression or somewhere else

Re: Find YTD

tyagishaila — Thu, 11 Dec 2014 06:40:11 GMT

Where should I write given expression for YTD,

in expression or somewhere else

I need YTD list box so that I can select required YTD

Re: Find YTD

its_anandrjs — Thu, 11 Dec 2014 06:41:53 GMT

Take Dimension and Expression in any straight chart or Bar chart

Dim1:- Year

Dim2:- Month

Expre:- =Sum( {$<Date = {'>$(=Max((YearStart(Date)))) <=$(=Max(Today()))'}>} Metrics )

This all are front end activity.

Regards

Anand

Re: Find YTD

Thu, 11 Dec 2014 06:45:12 GMT

write the code in expression tab.. and what do you mean by YTD list box?

you give filters year,month quarter.. and whenever you select any year or month or quarter,your chart show data respective to the selection

Re: Find YTD

tyagishaila — Thu, 11 Dec 2014 06:49:51 GMT

I have written but it shows numbers like 10282442

and in a ocloumn all YTD values are different

On Thu, Dec 11, 2014 at 12:15 PM, Bhawna Gupta <qcwebmaster@qlikview.com>

Re: Find YTD

Thu, 11 Dec 2014 06:52:24 GMT

post your sample application

Re: Find YTD

tyagishaila — Thu, 11 Dec 2014 06:54:39 GMT

I want table in this form

Store Name YTD 11-12 (Member Count) YTD 12-13 (Member Count) F M # Members

F M # Members Overall 40% 60% 558,588 42% 58% 603,816 NORTH 44% 56%

145,166 45% 55% 165,081 DELHI 50% 50% 38,166 50% 50% 51,720 LS-Ambey Mall

Vasant Kunj Delhi 53% 47% 11,986 53% 47% 14,053

On Thu, Dec 11, 2014 at 12:22 PM, Bhawna Gupta <qcwebmaster@qlikview.com>

Re: Find YTD

tyagishaila — Thu, 11 Dec 2014 06:57:35 GMT

Store Name	YTD 11-12 (Member Count)			YTD 12-13 (Member Count)
Store Name	F	M	# Members	F	M	# Members
Overall	40%	60%	558,588	42%	58%	603,816
NORTH	44%	56%	145,166	45%	55%	165,081
DELHI	50%	50%	38,166	50%	50%	51,720
LS-Ambey Mall Vasant Kunj Delhi	53%	47%	11,986	53%	47%	14,053

I want this type Pivot Table. There is also a problem that no. of members are shown after F and after M , not single time after F & M

Re: Find YTD

tyagishaila — Thu, 11 Dec 2014 08:43:49 GMT

Actually all time I don't want today's date,

I want year wise slots,

day and month must be Today's date but Year should not be

e.g.

YTD(11-12) is 1/1/2011 to 11/12/2012

YTD(12-13) is 1/1/2012 to 11/12/2013

YTD(13-14) is 1/1/2031 to 11/12/2014

This is for sale comparison, if I am comparing my sale today, than last year sale must be compare from start date to till date on last year

otherwise comparison will be wrong.

I think You understand my requirement

Re: Find YTD

tyagishaila — Thu, 11 Dec 2014 08:44:04 GMT

Actually all time I don't want today's date,

I want year wise slots,

day and month must be Today's date but Year should not be

e.g.

YTD(11-12) is 1/1/2011 to 11/12/2012

YTD(12-13) is 1/1/2012 to 11/12/2013

YTD(13-14) is 1/1/2031 to 11/12/2014

This is for sale comparison, if I am comparing my sale today, than last year sale must be compare from start date to till date on last year

otherwise comparison will be wrong.

I think You understand my requirement