topic Re: Count in script errors in QlikView

Count in script errors

Wed, 25 Nov 2020 16:16:04 GMT

Hi, hope someone can help me here, I'm getting an "Invalid expression" message with a line in my script and I can't see what's wrong.

For each area I want to count the number of times each distinct CODE_NUMBER is present when the STOCKSTATUS = SOLD

Thanks in advance

TMP_COUNT:
LOAD ID_NO,
count(CODE_NUMBER) as CODE_COUNT
Resident UNITS where STOCKSTATUS = 'SOLD' group by CODE_NUMBER, AREA;

Re: Count in script errors

MindaugasBacius — Thu, 26 May 2016 12:02:52 GMT

You should use the Group by ID_NO.

QV Help example:

Grouping data

Load ArtNo, round(Sum(TransAmount),0.05) as ArtNoTotal from table.csv group by ArtNo;

Load Week, ArtNo, round(Avg(TransAmount),0.05) as WeekArtNoAverages from table.csv group by Week, ArtNo;

Re: Count in script errors

jonathandienst — Thu, 26 May 2016 12:03:04 GMT

You need to include ID_NO in the Group By.

Re: Count in script errors

Digvijay_Singh — Thu, 26 May 2016 12:06:09 GMT

TMP_COUNT:
LOAD AREA,
count(CODE_NUMBER) as CODE_COUNT
Resident UNITS where STOCKSTATUS = 'SOLD' group by AREA;

Re: Count in script errors

Thu, 26 May 2016 12:07:17 GMT

Hi, ID_NO is my transaction ID and I want to count across all transactions not Individual ones as there is only ver 1 code per transaction, therefore that will only ever bring me back a 1

Thanks

Re: Count in script errors

PrashantSangle — Thu, 26 May 2016 12:22:32 GMT

Hi,

then comment ID_NO from the table.

Regards

Re: Count in script errors

Thu, 26 May 2016 12:26:57 GMT

Hi Simon

You don't need ID_No in your load statement

LOAD

AREA,

CODE_NUMBER,

count(CODE_NUMBER) as CODE_COUNT
Resident

UNITS

where

STOCKSTATUS = 'SOLD'

group by

AREA,

CODE_NUMBER;

Re: Count in script errors

Thu, 26 May 2016 12:31:53 GMT

Makes sense now, thank you guys