topic Re: if Skript in QlikView

if Skript

kkarlste — Mon, 03 Jul 2017 07:03:01 GMT

I want multiplication -1 if toimintoalue >= 006.

This bold skript is a new.

If I comment this bold skript this works ok

//FUNCTIONALAREAS

FunctionalArea:

LOAD "FKBER Functional Area" as TOIMINTOALUE,

if("FKBER Functional Area" >= '006',"TURNOVER Sales of the period" *-1),

// "TURNOVER Sales of the period" *

"TXTMD Medium description" as ToimintoSelite,

"FKBER Functional Area"&' '&"TXTMD Medium description" as FunctionalAreaSort, //13.10.

if("FKBER Functional Area" > '009','Toimihenkilöt',if("FKBER Functional Area" = '006', 'Palkansaajat')) as FuncAreaGroup,

if(FunctionalAreaLevel = 'CB0', 'SI CB', if(FunctionalAreaLevel = 'CB1', 'CU CB', if(FunctionalAreaLevel = 'CB2', 'DI CB', if(FunctionalAreaLevel = 'CB3', 'CO CB', FunctionalAreaLevel)))) as FunctionalAreaLevel,

Turnover,

CB0,

CB1,

CB2,

CB3,

AUC;

SQL SELECT *

FROM ISSQlikView.dbo."tb_src_SAP_MasterData_Functional_Area_2017";

ERROR MESSAGE

Re: if Skript

prma7799 — Mon, 03 Jul 2017 07:09:12 GMT

TURNOVER Sales of the period this field is missing in your Database table tb_src_SAP_MasterData_Functional_Area_2017

Re: if Skript

ahaahaaha — Mon, 03 Jul 2017 07:11:00 GMT

Hi,

Try

if("FKBER Functional Area" >= '006',"Turnover Sales of the period" *-1),

Re: if Skript

kkarlste — Mon, 03 Jul 2017 07:16:21 GMT

and now I skipt this Turnover

if("FKBER Functional Area" >= '006',"Sales of the period" *-1),

and this error

Field not found - <Sales of the period>

SQL SELECT *

FROM ISSQlikView.dbo."tb_src_SAP_MasterData_Functional_Area_2017"

Re: if Skript

prma7799 — Mon, 03 Jul 2017 07:23:35 GMT

first Load full table into in qvd Like

Test:

SQL SELECT *

FROM ISSQlikView.dbo."tb_src_SAP_MasterData_Functional_Area_2017";

Store Test into [FolderPath\Test.qvd(qvd)];

then check your filed name withe Test table .

Re: if Skript

kkarlste — Mon, 03 Jul 2017 07:39:48 GMT

Re: if Skript

arvind_patil — Mon, 03 Jul 2017 07:45:29 GMT

Hi Kalle,

It may be filed name has changed in base data.

first load full table and check the name its vary from your previous one.

Thanks,

Arvind Patil

Re: if Skript

ahaahaaha — Mon, 03 Jul 2017 07:45:30 GMT

QlikView don't find field [Sales of the period] in your SQL base. You need to determine how the required field is named in the SQL base.

Re: if Skript

prma7799 — Mon, 03 Jul 2017 07:45:37 GMT

remove SQL word from select statement and execute query

Re: if Skript

fvelascog72 — Mon, 03 Jul 2017 07:47:07 GMT

Hi,

Don´t write SQL at the beginning. Just SELECT.

Cheers.

Re: if Skript

kkarlste — Mon, 03 Jul 2017 08:00:36 GMT

And now.
What is next step?

Re: if Skript

fvelascog72 — Mon, 03 Jul 2017 08:40:13 GMT

Hi,

In your Database table you don´t have "TURNOVER Sales of the period" field, so this if doesn´t work.

if("FKBER Functional Area" >= '006',"TURNOVER Sales of the period" *-1),

// "TURNOVER Sales of the period" *

"TXTMD Medium description" as ToimintoSelite,

Saludos.

Re: if Skript

kkarlste — Mon, 03 Jul 2017 08:55:27 GMT

Is not in this table, but there is another table.

Have you any ideas?

Re: if Skript

fvelascog72 — Mon, 03 Jul 2017 09:02:30 GMT

The SQL statement doesn´t read this field, so you have to do the IF where the two fields ("FKBER Functional Area" and "TURNOVER Sales of the period") were realtioned.

Re: if Skript

ahaahaaha — Mon, 03 Jul 2017 09:04:52 GMT

In the picture there is a "tb_src_SAP_Actuals' table with a field of [TURNOVER Sales of the period]. In script code at the beginning of this post data load from SAP to "FunctionalArea" table. It is not yet clear how they are connected at all, so that they can be used together.