topic YTD and Set Analysis in QlikView

YTD and Set Analysis

Wed, 14 Apr 2010 20:05:01 GMT

User selects 2010 in a list box and March in another list box. I need a chart (straight table) that in one column show March's total sales and in the second column shows YTD sales.

Seem to be brain dead today

Help,

Stephen

YTD and Set Analysis

Wed, 14 Apr 2010 20:30:22 GMT

By the way, the user also selects a territory from a list box.

YTD and Set Analysis

Wed, 14 Apr 2010 20:51:30 GMT

If you are forcing them to select a month, then that is all you would need for March.

For YTD, why don't you just use set analysis and turn off the month selection - keeping all else the same. (assuming your month field is just Month)

Sum({$<Month=>} yourAmount)

$ = current selections

<Month=> = removes Month selection

YTD and Set Analysis

johnw — Wed, 14 Apr 2010 20:52:44 GMT

I think this:

March 2010 = sum(Sales)
March 2010 YTD = sum({<Month={"<=$(=Month)"}>} Sales)

YTD and Set Analysis

Wed, 14 Apr 2010 21:07:06 GMT

wshpuntoff worked.

Thanks.

YTD and Set Analysis

Mon, 27 Jun 2011 12:20:17 GMT

Hi wshpuntoff

Can this be done in a Cyclic Group? If yes then please help me out!

Thanks

Attitude

YTD and Set Analysis

Thu, 21 Jul 2011 15:23:29 GMT

Hi John

Can it be done used as one of the field along with Year/Quarter/Month/Week. If it can be done then please let me know on that.

Regards

Attitude

YTD and Set Analysis

Thu, 21 Jul 2011 15:54:53 GMT

You can use the function GETCURRENTField and pas your Cyclic group Name.

Re: YTD and Set Analysis

Thu, 21 Jul 2011 16:37:27 GMT

Thanks asomani! This is something similar to what I was looking for but not very sure whether it give the expected result or not.

Could you please give me more detail on how to use this inside the Cyclic Group please.

Are you expecting me to do something like below? For your information as "getcurrentfield" gives the field which is selected in the group I have passed '=''' for the YTD. Hope I am doing the right thing here. If not please do let me know.

if(getcurrentfield(MyGroup)='=''',Count({<[Month] =, [Year] = {'$(vMaxYear)'}>} ID),Count(ID))

Re: YTD and Set Analysis

Thu, 21 Jul 2011 18:36:07 GMT

Correct. Now based on this you know what Column you viewing and what expression you should be consider

Regards,

Amit

Re: YTD and Set Analysis

Fri, 22 Jul 2011 04:58:13 GMT

Hi Amit

Are you sure that above code will work as expected. Because when I used the above code it throws the error saying that "Bad field name(s),MyGroup". Also I used above code in only in expression but rest of the expression give the expetected result may be as I used '=''' in the YTD and also it contains only year. So I guess because of this only it is giving the expected result and not because of the above code. Hope my expectation are understandable. If not please let me know.

Regards

Attitude

Re: YTD and Set Analysis

deepakk — Sun, 24 Jul 2011 04:51:51 GMT

HI Attitude,

Try out the attach application.