Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
qlikmsg4u
Valued Contributor

Re: Set analysis

9 Replies
gautik92
Valued Contributor III

Re: Set analysis

qlikmsg4u
Valued Contributor

Re: Set analysis

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),

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

qlikviewwizard
Honored Contributor II

Re: Set analysis

Not applicable

Re: Set analysis

Could any one attach related qvd for this example

qlikmsg4u
Valued Contributor

Re: Set analysis

gautik92
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

Highlighted
qlikmsg4u
Valued Contributor

Re: Set analysis

Yes absolutely,

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