topic Re: function in agrr in QlikView

function in agrr

Wed, 07 Nov 2012 08:44:12 GMT

Hi!

May be anyone know why i can't use such thing:

Aggr(sum(Quantity_i),AffiliateID, bg_t, Id,left(date_a,6))

exp. i have date_a:

20120101

20120102

20120201

20120305

and i need use Aggr with only month not full date

i try use left(date_a,6) but it is not working

Re: function in agrr

sujeetsingh — Wed, 07 Nov 2012 09:03:31 GMT

Hi yes you can not get the month this way.

-First of all tell the date format'dd/mm/yy' or what??

try this----

=right(left(Date#(last_accessed),6),2)

Lets see

Re: function in agrr

Wed, 07 Nov 2012 09:13:19 GMT

hi, sujeetsingh!

field "date_a" in my table is in format - varchar(15)

Re: function in agrr

Wed, 07 Nov 2012 09:26:10 GMT

Hai

pls use conditional dimension for that date_a field

there u need put

left(date(date_a,6))

Re: function in agrr

Wed, 07 Nov 2012 09:28:36 GMT

sorry pls use right(field name ,2)

Re: function in agrr

somenathroy — Wed, 07 Nov 2012 10:13:17 GMT

Hi,

At script level you may create a field, Left(date_a,6) as month.

Then within expression you may use Aggr(sum(Quantity_i),AffiliateID, bg_t, Id, month)

Regards,

Som

Re: function in agrr

Wed, 07 Nov 2012 10:57:59 GMT

Hai

You mean create new field when i load data with condition?

Re: function in agrr

Wed, 07 Nov 2012 11:04:19 GMT

it is works thank you

is it not alowed any functions such as left(field,n) inside Aggr function because of Syntaxis?

and any time i have to add new fields with conditions?

Re: function in agrr

somenathroy — Wed, 07 Nov 2012 11:49:35 GMT

As per my knowledge, Aggr function takes only dimensions not calculated dimesions.

Regards,

Som

Re: function in agrr

Wed, 07 Nov 2012 11:51:31 GMT

thank you !