INVALID EXPRESSION , IF script function

luisccmm — Sat, 16 Nov 2024 01:47:05 GMT

Hi,

Why the following SCRITP code is FAILING in this "IF" FUNCTION,

IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1

ERROR: Invalidad Expression

That IF function is located at the bottom.

Conversion_rates_mapping: Mapping LOAD Action, Conver_rate FROM [lib://TEST APP/Conversion_rates.xlsx] (ooxml, embedded labels, table is CONVERSION_RATES); [DATE_PRODUCTION]: LOAD "Date", Action, Production, Production *ApplyMap('Conversion_rates_mapping', Action) as SALES_CONVERTED FROM [lib://TEST APP/Conversion_rates.xlsx] (ooxml, embedded labels, table is DATE_PRODUCTION); [DATE_PRODUCTION_3]: NoConcatenate LOAD "Date", IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1 Conversion_rates_mapping: Mapping LOAD Action, Conver_rate FROM [lib://TEST APP/Conversion_rates.xlsx] (ooxml, embedded labels, table is CONVERSION_RATES); [DATE_PRODUCTION]: LOAD "Date", Action, Production, Production *ApplyMap('Conversion_rates_mapping', Action) as SALES_CONVERTED FROM [lib://TEST APP/Conversion_rates.xlsx] (ooxml, embedded labels, table is DATE_PRODUCTION); [DATE_PRODUCTION_3]: NoConcatenate LOAD "Date", IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1 Resident [DATE_PRODUCTION]; Resident [DATE_PRODUCTION];

Re: INVALID EXPRESSION , IF script function

Arthur_Fong — Fri, 06 Dec 2019 03:33:42 GMT

When we are performing aggregation at script, eg(Sum):

Group by clause is required.

[DATE_PRODUCTION_3]: NoConcatenate LOAD "Date", IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1 resident <Your TableName> Group by Date;

Re: INVALID EXPRESSION , IF script function

Jesh19 — Fri, 06 Dec 2019 04:16:56 GMT

You're missing Group By in your script.

Try this..

Load Date,

IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1

Resident Date_Production

Group By Date;

topic Re: INVALID EXPRESSION , IF script function in QlikView

INVALID EXPRESSION , IF script function

Re: INVALID EXPRESSION , IF script function

Re: INVALID EXPRESSION , IF script function