topic script error in QlikView

script error

Anonymous — Tue, 07 Jun 2011 17:03:26 GMT

med:
Load *,
 If(FORMID = 'H' AND LOS > 1 , Total) as IH_Total,
 If(FORMID = 'H' AND LOS = ' ', Total) as OH_Total,
 If(FORMID = 'P', Total) as P_Total,
 If(FORMID = 'N', Total) as N_Total,
 sum(Total) as SumMedTotal;
LOAD
 MEM#,
 //MEM# & FORMID AS MEDFORMMED, 
 //MEM# as Med_MEM#,
 //MEM# as Medd, 
 ENCOUNTER#,
     '3rd Quarter 2011' as Period, //Create a column calls period and populate it with the 3rd text //
     '261740' AS MM,
     '1.26' AS ACG,
     [VEND NAM], 
     [TAX ID], 
     [TOTAL PAID] as Total, 
     SERVICE, 
     DISCHARGE, 
     LOS,
     [ICD9 DIAG], 
     [FORM TYPE],
     //IF([FORM TYPE]='HCFA 1450','H',If([FORM TYPE]='HCFA 1500','P',If([FORM TYPE]='NARRATIVE',' ','N'))) AS FORMID_MED,
      IF([FORM TYPE]='HCFA 1450','H',If([FORM TYPE]='HCFA 1500','P',If([FORM TYPE]='NARRATIVE',' ','N'))) AS FORMID  
FROM
Data\Dimensions\med.qvd
(qvd);

script error

Miguel_Angel_Baeyens — Tue, 07 Jun 2011 17:05:52 GMT

Hi,

Can you please elaborate on the error you are experiencing and what are you trying to get?

At a first glance, it seems you are using an aggregation function Sum() without the corresponding GROUP BY clause.

Regards,

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

script error

isaiah82 — Tue, 07 Jun 2011 17:06:28 GMT

Immediately I see that you have an aggregate function: sum(Total) in your load statement but no GROUP BY clause. Please be sure and post some additional information (e.g. what error message are you getting, when, etc. and your specific question when posting to the forum.

Thanks -Isaiah

script error

Anonymous — Tue, 07 Jun 2011 17:11:17 GMT

SumMedTotal,

LOAD

MEM#,

ENCOUNTER#,

'3rd Quarter 2011' as Period,

'261740' AS MM,

'1.26' AS ACG,

[VEND NAM],

[TAX ID],

[TOTAL PAID] as Total,

SERVICE,

DISCHARGE,

LOS,

[ICD9 DIAG],

[FORM TYPE],

IF([FORM TYPE]='HCFA 1450','H',If([FORM TYPE]='HCFA 1500','P',If([FORM TYPE]='NARRATIVE',' ','N'))) AS FORMID

FROM

Data\Dimensions\med.qvd

(qvd)

Above is the script error. It does not specified any other error except script error.

Thanks.

Re: script error

Wed, 24 Sep 2014 14:41:23 GMT

I think GroupBy clause and FORMID field information is missing.

Re: script error

ToniKautto — Wed, 24 Sep 2014 15:28:51 GMT

In this example you have a comma on the first line, which is a syntax error. I suspect that this is not exactly the script you execute.

My suggestion is that you enable document log in your application, then reload once with the error and provide a copy of the document log.

QlikView Desktop client > Settings > Document Properties
General tab
Check "Generate Logfile"
Reload the document

There will be a file named as the application but with .log as extension. Please attach that to this thread.