topic Re: Invalid Expression in Script (if) in QlikView

Invalid Expression in Script (if)

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

hi,

Please see what is wrong with my syntax, This exact formula works on the frontend but doesnt work in the script. No idea why,

Script below:

RAWTABLE:

Load Ticket Typ,

RecSite

.......

Load Count([Ticket Typ]) as TotalClaims,

if(mid(RecSite,2,1)='F','Franchise','Corporate') as Type

Resident RAWTABLE;

Formula in question is in bold.

Re: Invalid Expression in Script (if)

oknotsen — Mon, 04 Jul 2016 08:24:41 GMT

Function seems to be fine, though I do get the idea your are missing a "group by" to make that count work.

Re: Invalid Expression in Script (if)

Peter_Cammaert — Mon, 04 Jul 2016 08:34:18 GMT

You cannot use a Count() aggregation function and an individual field-that-isn't present-in-a-GROUP-BY clause in the same load. In addition to that, there is no GROUP BY clause. What are you planning to do?

Re: Invalid Expression in Script (if)

Anonymous — Mon, 04 Jul 2016 08:38:49 GMT

All i need the count for is to do calculations on the frontend (Percentages). So il just remove the code from the script and add it to the frontend.

Re: Invalid Expression in Script (if)

oknotsen — Mon, 04 Jul 2016 08:48:56 GMT

For that I suggest you do that Type calculation (that IF statement) in your script and do the count in the front-end anyway.

The expression to calculate your percentage will be something like this:

count([Ticket Type]) / count(TOTAL [Ticket Type]

Re: Invalid Expression in Script (if)

omkarvamsi — Fri, 18 Nov 2016 07:21:40 GMT

1.we need to use Group By in script when we are using aggregating functions like SUM,MIN,MAX,COUNT....

2.in group by we have to use all the dimensions using in the load statement.

3.for example:

LOAD COUNTRY,

REGION,

SUM(POPULATION)

FROM TABLE.QVD

GROUP BY COUNTRY,REGION;

Re: Invalid Expression in Script (if)

Anonymous — Fri, 18 Nov 2016 10:04:23 GMT

Add Count([Ticket Typ]) in front end and keep you expression in script as it is.

If you want to do it in script use by Groupby .

load

if(mid(RecSite,2,1)='F','Franchise','Corporate') as Type

Resident RAWTABLE

;