topic Re: No count in load script in QlikView

No count in load script

Fri, 26 Apr 2013 11:37:03 GMT

Hello users,

I have a problem with count in load script. It doesn't work, I think because there is no group by and no resident table. I don't know how to write the right command. The field "Signatur" is in the same table and has field @46.

Perhaps you can help me.

Thank you,

Inga

Re: No count in load script

Gysbert_Wassenaar — Fri, 26 Apr 2013 11:39:17 GMT

All the fields not used in an aggregation function, like count, need to be included in the group by clause at the end of the load statement:

Load A, B, count(C), D

from ...somewhere...

group by A,B,D;

Re: No count in load script

Fri, 26 Apr 2013 12:02:59 GMT

load

signatur,

count(signatur)

resident tablename

group by signatur;

******************************

or also try this

load

A , // field on the basis of it perform count

count(signatur)

resident tablename

group by A;

Re: No count in load script

Fri, 26 Apr 2013 12:30:23 GMT

Thanks Gysbert,

I think your answer is helpful for many people. But... on the screenshots you can see, that I not often work with SQL and functions.

But... I try... And I'm happy that it would be easy! When I know or better understand the answer, I will never forget it. Here's my nice try:

Looks soooo nice. But doensn't work.

Greets,

Inga

Re: No count in load script

Fri, 26 Apr 2013 12:33:57 GMT

Hey Vishwaranjan,

nice, it looks so easy, but it doesn't work. The field "Signatur" with A @46 is in the same table like "Exemplazählung" with A @19.

Perhaps I can make the group by at the end of this table, like I've done it with Gysberts answer.

I don't want to give up. :-S

Greets,

Inga

Re: No count in load script

Gysbert_Wassenaar — Fri, 26 Apr 2013 12:34:42 GMT

Ok, let's try that again with a little emphasis this time

All the fields not used in an aggregation function, like count, need to be included in the group by clause at the end of the load statement

That really means all. Every field you load that is not used in an aggregation function must be included in the group by statement. If you load 10 fields and use two fields in aggregation functions that means you should have 8 fields in the group by clause.

Re: No count in load script

Fri, 26 Apr 2013 12:43:50 GMT

Thank you for your patience.

Oooh, okay, there are 82 field that don't need a group by. Uiii, I have to try it.

Re: No count in load script

Sun, 28 Apr 2013 10:50:31 GMT

Okay, it works like you said it.

count(@46) as Exemplarzählung

FROM...

group by @1, @2, @3 ... @83;

Thank you so much!

Inga