topic Re: Set analysis in QlikView

Set analysis

Wed, 16 Sep 2015 06:58:19 GMT

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 .

Re: Set analysis

gautik92 — Wed, 16 Sep 2015 07:01:04 GMT

Have a look at this

Set Analysis for Rolling Periods

Re: Set analysis

qlikmsg4u — Wed, 16 Sep 2015 07:04:31 GMT

And this

YTQ, QTD, MTD and WTD

Re: Set analysis

Wed, 16 Sep 2015 07:05:50 GMT

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

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

Re: Set analysis

qlikviewwizard — Wed, 16 Sep 2015 07:10:59 GMT

Hi,

Check this links:

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Re: Set analysis

Wed, 16 Sep 2015 07:11:28 GMT

Could any one attach related qvd for this example

Re: Set analysis

qlikmsg4u — Wed, 16 Sep 2015 07:13:35 GMT

PFA

Re: Set analysis

gautik92 — Wed, 16 Sep 2015 07:16:21 GMT

Have a look at this

Re: Set analysis

Wed, 16 Sep 2015 07:17:41 GMT

thanku kN

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

Re: Set analysis

qlikmsg4u — Wed, 16 Sep 2015 07:19:23 GMT

Yes absolutely,

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