topic Re: Script error in QlikView

Script error

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

Hi,

I have used the below query in script level but it is giving the below error.

Logic : concat(A7BANB,',') as new,

Re: Script error

sunny_talwar — Thu, 02 Feb 2017 10:32:55 GMT

You forgot to use Group By statement at the end

Re: Script error

Chanty4u — Thu, 02 Feb 2017 10:36:33 GMT

Concat function required group by clause I think.

May be you required a group by clause at the end of your script

group by Category1...

Re: Script error

tyagishaila — Thu, 02 Feb 2017 10:42:05 GMT

You are missing group by function.

Re: Script error

nareshthavidishetty — Thu, 02 Feb 2017 11:39:44 GMT

Hi ,

I have used the below script but still i'm not able to merge the invoice numbers into one row.

Requirement: In the below image for salesman Balka,Damion the invoice # is showing as

30777459

30777609

30778676

30778882

30780296

Here ineed to show them in single row as 30777459,30777609,30778676,30778882,30780296

Image:

Script:

LOAD

'Sign' as flag,

A7AJCD,

A7AACD as Loc,

A7AIDT as Date,

ESIGN_COMPLETE_NEW as Sales,

'Complete'&'-'&SIGN_COMPLETE_NEW as Category1,

Concat(A7BANB, ', ') as NEW,

A7BANB,

APA0TX

FROM

(qvd)Group By A7AACD,A7AIDT,ESIGN_COMPLETE_NEW,A7BANB,APA0TX,A7AJCD;

Thanks..

Re: Script error

sunny_talwar — Thu, 02 Feb 2017 11:51:59 GMT

Which field is location and which one is salesman in the above script?

Re: Script error

sdmech81 — Thu, 02 Feb 2017 11:58:51 GMT

in group by u have missed,

SIGN_COMPLETE_NEW

plss add that n try

Sachin

Re: Script error

nareshthavidishetty — Thu, 02 Feb 2017 12:04:59 GMT

Hi ,

Please find below.

Location : A7AACD as Loc

SalesMan : APA0TX

Invoice # : Concat(A7BANB, ', ') as NEW

Sales : ESIGN_COMPLETE_NEW as Sales

Thanks..

Re: Script error

sunny_talwar — Thu, 02 Feb 2017 12:06:52 GMT

Try this:

Script:

LOAD

'Sign' as flag,

A7AJCD,

A7AACD as Loc,

A7AIDT as Date,

ESIGN_COMPLETE_NEW as Sales,

'Complete'&'-'&SIGN_COMPLETE_NEW as Category1,

A7BANB,

APA0TX

FROM

(qvd);

Left Join (Script)

LOAD A7AACD,

APA0TX,

Concat(A7BANB, ', ') as NEW

Resident Script

Group By A7AACD, APA0TX;

Re: Script error

nareshthavidishetty — Thu, 02 Feb 2017 13:15:54 GMT

Hi,

Now am able to get all those numbers into one row.

Here i need to get those sales count also needs to add.Here i need to get total as 3 with in single cell.

Color metric calculation(dimension):

=aggr(num((sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales))

/(sum({<Date={$(varMaxDate)},flag={'Wet Sign'}>} Sales)+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales)

+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>} Sales)),'

#,##0.0%'),Loc,APA0TX,A7BANB)

Expression:

sum({<Date={$(varMaxDate)}>} Sales)

Thanks..

Re: Script error

sunny_talwar — Thu, 02 Feb 2017 13:19:20 GMT

Not sure I understand