topic Re: Dimmension like as into the script in QlikView

Dimmension like as into the script

pgalvezt — Wed, 25 Jul 2012 15:21:53 GMT

hello, I have this in my Dimmension Calculated. Works fine, but Consume a lot of memory How can I traslate this into the script and finally left it like "as".?

if(aggr(sum(date(vDate)-Field1),Field2)= vDate, Dual('YTD',1),

if(aggr(sum(date(vDate)-Field1),Field2)>=1 And aggr(sum(date(vDate)-Field1),Field2)<=30, Dual('Period1',2),

if(aggr(sum(date(vDate)-Field1),Field2)>=31 And aggr(sum(date(vDate)-Field1),Field2)<=60, Dual('Period2',3))))

Thanks,

Re: Dimmension like as into the script

Wed, 25 Jul 2012 15:35:37 GMT

In the data model if Field1 and field2 are in same table; add a column in the script with same if conditions and using group by Field1. Use left join to ensure unnecessary results are not included.

Kiran.

Re: Dimmension like as into the script

pgalvezt — Wed, 25 Jul 2012 17:39:29 GMT

Thanks for your reply. I Tried to put your information on my qvw but doesn't work I attached an example with my code.

Re: Dimmension like as into the script

Wed, 25 Jul 2012 18:23:46 GMT

Try this.

Kiran.

Re: Dimmension like as into the script

pgalvezt — Wed, 25 Jul 2012 20:05:31 GMT

Thanks. Just last question.

I had a variable Let and I have created a Calendar Object where I choose the last month, so all Fields1 are subtracted on 31/01/2012 for example. So I know you put a variable: Vdate = Today(); How should the variable stay If:

Vdate-Field1 ==> Where Vdate is endMonth.?

Vdate=EndMonth(); ?

Thanks.

Re: Dimmension like as into the script

Thu, 26 Jul 2012 02:07:32 GMT

Since the periods are defined in script, they cannot be changed in expression level.

To get end of month use MonthEnd(today()).

Kiran.

Re: Dimmension like as into the script

pgalvezt — Thu, 26 Jul 2012 19:18:23 GMT

Many Thanks.