Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

YTD and MTD in qlikview

Hello All,

Can you please suggest how to convert YTD and MTD values in QV.

Thanks

1 Solution

Accepted Solutions
Not applicable

Hi Deepak,

do a search on the community and you will find many example of people asking about MTD and YTD, I suggest having a look first.

Two below from a quick search

YTQ, QTD, MTD and WTD

YTD MTD

Joe

View solution in original post

3 Replies
Not applicable

Hi,

You can calculate MTD and YTD using set analysis

Plz refer to this doc for explanation

YTQ, QTD, MTD and WTD

Hope this helps!.

Vivek

Not applicable

Hi Deepak,

do a search on the community and you will find many example of people asking about MTD and YTD, I suggest having a look first.

Two below from a quick search

YTQ, QTD, MTD and WTD

YTD MTD

Joe

juhoheino
Contributor III
Contributor III

Hi,

I would suggest using the same approach as Miguel Garcia and Barry Harmsen in the book 'QlikView 11 for Developers', i.e. declaring many different sets (MTD, MTD Last Month, YTD, YTD Last Year...) in a text file, from which they are loaded into variables. When you write set analysis for your expressions, all you need to do is reuse these expressions - I have not had to touch mine for a long time, which simplifies development a great deal.

Cheers,

Juho