# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

## Set analysis

Hi,

i Know set analysis.but i want to how to use ytd,mtd,lytd,mytd, and where to use any particular senario for using this

i would be  grate if u attach any qvd related to this .

Tags (1)
1 Solution

Accepted Solutions
Valued Contributor

## Re: Set analysis

PFA

9 Replies
Valued Contributor III

## Re: Set analysis

Valued Contributor

Not applicable

## Re: Set analysis

We have similar work we do. This is how we do mtd and ytd. Our financial year is July to June. There are probably easier ways to do this, but maybe this helps

MTD

if(Month='Jul',sum(BudgetJul),

if(Month='Aug',sum(BudgetAug),

if(Month='Sep',sum(BudgetSept),

if(Month='Oct',sum(BudgetOct),

if(Month='Nov',sum(BudgetNov),

if(Month='Dec',sum(BudgetDec),

if(Month='Jan',sum(BudgetJan),

if(Month='Feb',sum(BudgetFeb),

if(Month='Mar',sum(BudgetMar),

if(Month='Apr',sum(BudgetApr),

if(Month='May',sum(BudgetMy),

if(Month='Jun',sum(BudgetJun),

))))))))))))

YTD

if(Month='Jul',sum(BudgetJul),

if(Month='Aug',sum(BudgetJul+BudgetAug),

if(Month='Sep',sum(BudgetJul+BudgetAug+BudgetSept),

if(Month='Oct',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct),

if(Month='Nov',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov),

if(Month='Dec',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec),

if(Month='Jan',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan),

if(Month='Feb',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb),

if(Month='Mar',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar),

if(Month='Apr',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar+BudgetApr),

if(Month='May',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar+BudgetApr+BudgetMy),

if(Month='Jun',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar+BudgetApr+BudgetMay+BudgetJun),

))))))))))))

Honored Contributor II

Highlighted
Not applicable

## Re: Set analysis

Could any one attach related qvd for this example

Valued Contributor

## Re: Set analysis

PFA

Valued Contributor III

## Re: Set analysis

Have a look at this

Not applicable

## Re: Set analysis

thanku kN

is it same steps we will follow for  lytd,mytd,qtd

Valued Contributor

## Re: Set analysis

Yes absolutely,

See the above links given by other members if you find any difficulty