topic Re: YTD in QlikView

YTD

Sun, 14 Sep 2014 03:48:07 GMT

Hi All

The below note is taken from qlik developer ebook, As per the below instruction, how do i create Max (period) expression in qlikview

A simple Max(Period) expression will help us get the base period in all scenarios,

as the Period field contains both the Month and Year components. Therefore, the set

modifiers that we would use to get the record set corresponding to the base period in

each of the required comparisons are:

• Current Year-To-Date indicators:

<Period = {"<=$(=Max(Period))"}, Year = {"$(=Max(Year))"}, Quarter= , Month = >

This set modifier will result in a record set containing all of the periods that

are less than or equal to the current period, and belong to the current year,

which would be all Year-To-Date records.

Re: YTD

sebastiandperei — Sun, 14 Sep 2014 05:47:38 GMT

Sorry, i cant understand the question...

Re: YTD

Sun, 14 Sep 2014 05:52:16 GMT

the below query does not work in qlikview .the below set analysis is correct ?

<Period = {"<=$(=Max(Period))"}, Year = {"$(=Max(Year))"}, Quarter= , Month = >

Re: YTD

Sun, 14 Sep 2014 06:53:45 GMT

Hi,

Are you getting some expression error or unexpected result ?

The modifier looks okay.

This set modifier will result in a record set containing all of the periods that

are less than or equal to the current period, and belong to the current year,

The expression would take all periods less than or equal to selected period. Not exactly Current Period.

In case of year, it will take maximum year out of the current selection of year.

Hope this help !

Regards,

Kalpesh

Re: YTD

Mon, 15 Sep 2014 23:36:00 GMT

Hi All

I would like develop a bar chart as shown below, appreciate, if anyone help me to identify what needs to be done (including creation of variables)

Jayanthan

Re: YTD

Tue, 16 Sep 2014 20:23:21 GMT

There are many discussions, documents and applications you will find in this community.

QlikView App: Year To Date Using Set Analysis

YTD,QTD MTD Tables with Sum(Sales)

Calculating Year To Date Accumulation Expression

And many more.

Still if you are stuck, you may share your sample data here

Best Regards,

Kalpesh