Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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

PFA

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

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

Arjunarao
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

PFA

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

qlikmsg4u
Valued Contributor

Re: Set analysis

Yes absolutely,

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