Find YTD

[tyagishaila]

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

[its_anandrjs]

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

[arulsettu]

hi

check this

YTQ, QTD, MTD and WTD

[#4]

attached document can help you..

[tyagishaila]

Where should I write this expression,

in expression or somewhere else

[tyagishaila]

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

[its_anandrjs]

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

[#8]

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

[tyagishaila]

Ok

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>

[#10]

post your sample application