topic Re: How to Write Aggr Function script in Script Editor in QlikView

How to Write Aggr Function script in Script Editor

brijeshvma — Wed, 25 Nov 2020 16:16:04 GMT

Hi All i have a two table in one i have all the dimension and second table have a Aggregated value for the same ..

and both are connected with common field.. But when i do sum(visits) i get wrong output ..

and if i am writing a sum(Aggr(Visits,VisitFull,Date)) Expre. i am getting a correct value .. But because of aggr function it slow down the

application .. so is there any way i can join this table and directly write this expression on script editor .. so on expression by directly

writing sum(visits) it gives proper value .. I am attaching qvd and qvw file .. kinldy check and help me how to achive this....

Re: How to Write Aggr Function script in Script Editor

sunny_talwar — Wed, 11 May 2016 09:17:37 GMT

Would you be able to share a smaller sample?

Preparing examples for Upload - Reduction and Data Scrambling

Re: How to Write Aggr Function script in Script Editor

brijeshvma — Wed, 11 May 2016 09:29:09 GMT

Hi Sunny,

Kindly find the attachment.

Re: How to Write Aggr Function script in Script Editor

brijeshvma — Wed, 11 May 2016 09:30:45 GMT

Hi Sunny,

i selected more filter option. now it less than 5 Mb .. !

Re: How to Write Aggr Function script in Script Editor

brijeshvma — Wed, 11 May 2016 09:49:03 GMT

Hi All,

Can any one suggest me how to achieve this ?

Re: How to Write Aggr Function script in Script Editor

brijeshvma — Wed, 11 May 2016 10:03:58 GMT

Hi Sunny ,

Are you able to check the qvw ?

Re: How to Write Aggr Function script in Script Editor

ashishkalia — Wed, 11 May 2016 10:05:03 GMT

Boss it seems data modelling issue. pl look below

Re: How to Write Aggr Function script in Script Editor

brijeshvma — Wed, 11 May 2016 10:08:07 GMT

Hi Ashish,

I am Having only two table .. one having event level dimension and another is aggregated value for that visits..

So how resolve this ?

Re: How to Write Aggr Function script in Script Editor

ashishkalia — Wed, 11 May 2016 10:10:37 GMT

can you share the data?

with some info regarding wat you are doing?

Re: How to Write Aggr Function script in Script Editor

sunny_talwar — Wed, 11 May 2016 10:11:46 GMT

Can you try this script at the end of the script:

Aggr:

LOAD VisitFull,

Visits

Resident Second;

Left Join (Aggr)

LOAD VisitFull,

Link_Date

Resident First;

Left Join (Aggr)

LOAD Link_Date,

Date

Resident [Master Calendar];

TempAggr:

LOAD DISTINCT VisitFull,

Date,

Visits

Resident Aggr;

FinalTableAggr:

LOAD VisitFull,

Date,

Sum(Visits) as TotalVisits

Resident TempAggr

Group By VisitFull, Date;

DROP Table Aggr, TempAggr;

And use TotalVisits in your chart

Re: How to Write Aggr Function script in Script Editor

brijeshvma — Wed, 11 May 2016 10:41:54 GMT

Hi Sunny thanks for ur reply,

But can u tell me if i do this with more dimension that i have

Aggr:

LOAD VisitFull,

Visits

Resident Second;

Left Join (Aggr)

LOAD VisitFull,

Channel,

Action ,

Category,

Link_Date

Resident First;

So say example in second table i have Value 1 for Visitfull

VisitFull Visits Channel Action Category

101/10001 1 FB Click On-Page

101/10001 1 FB Impression On-page

so session count for 101/10001 is 2 ..sum(Visits)... but it should come 1

Re: How to Write Aggr Function script in Script Editor

sunny_talwar — Wed, 11 May 2016 10:43:58 GMT

Why would you want to do it with more dimensions? Just use those dimensions which are needed, extra dimensions are going to throw your results of.

Re: How to Write Aggr Function script in Script Editor

brijeshvma — Wed, 11 May 2016 11:18:03 GMT

Hi Sunny but i want those channel as a Filter and chart like dimension as channel and Measures will be sum(Visits)

Re: How to Write Aggr Function script in Script Editor

sunny_talwar — Wed, 11 May 2016 11:39:29 GMT

I have done a binary load and it seems the results are not exact, but are close. I will continue to troubleshoot. But have a look