topic Re: Calculation on Script in QlikView

Calculation on Script

icaro_povoa — Sat, 16 Nov 2024 04:50:17 GMT

Deal All,

I am trying to build a dashboard witch will be a combination of a lot of Excel files.

To avoid creating SK, I am trying to rename the attributes according to one unique nomenclature and doing a join on all other tables.

Basically I am creating attributes to be filters ( Country, Month, Year, Region....) and one unique attribute called Results for being my expression.

The issue is that not all the tables, my result is located in a unique column. Sometimes I will need to have a calculation for creating this attribute "Results".

The most comum calculatation that I need is something like.

((CRITERIA1)/(CRITERIA2))*100 as Results

When trying this, I am receiving an error on the script. (Invalid Expression)

I am quite new on script modeling, so please let me know if this is not the best approach.

Regards

Re: Calculation on Script

Clever_Anjos — Mon, 07 Jan 2019 11:31:57 GMT

Would you mind posting your script that generates the error?

_________
Clever dos Anjos
Have fun, be Qlik 🙂

Re: Calculation on Script

icaro_povoa — Mon, 07 Jan 2019 12:59:50 GMT

Follow the script:

QUALIFY Comments;
Directory;
NAKPIS:
LOAD KPI,
BSC,
Territory,
Team,
Crop,
Brand,
Month,
Result,
Grouping,
Lower,
Upper,
[Traffic Light]

FROM
Example.xlsm
(ooxml, embedded labels, table is Database);

HSE:
Directory;
Join(NAKPIS)
LOAD 'IIR' as KPI,
'Safety' as BSC,
'Strategic' as Grouping,

Month ,
[Hours Worked],
Recordables,
(sum(Recordables)/sum([Hours Worked])*200000) as Result

FROM
.....

Re: Calculation on Script

Clever_Anjos — Mon, 07 Jan 2019 13:11:43 GMT

LOAD 'IIR' as KPI,
'Safety' as BSC,
'Strategic' as Grouping,

Month ,
[Hours Worked],
Recordables,
(sum(Recordables)/sum([Hours Worked])*200000) as Result

FROM

If you have a sum() you´re supposed to have a GROUP BY clause, do you have one?

Re: Calculation on Script

icaro_povoa — Mon, 07 Jan 2019 13:15:27 GMT

Hi,

No I don´t. Can you help me with this?

I have no idea how to do it. 😕

Regards