topic Re: Invalid expression error in script while reload data in QlikView

Invalid expression error in script while reload data

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

Hi ,

I am getting error like invalid expression while reloading below script. example like

Tab1:

Load Empno,

Empname,

Deptno,

Branch,

Sales,

if(Branch='Pune',Sum(Sales) as value

C:\Users\pdontham\Desktop\ScheduledvsOffCycleReleases.xlsx

(ooxml, embedded labels, table is Sheet1);

Please let me know where i am wrong with the expression.

Thanks,

Raj

Re: Invalid expression error in script while reload data

tresB — Mon, 06 Feb 2017 06:10:25 GMT

Try like:

Tab1:

Load Empno,

Empname,

Deptno,

Branch,

Sales,

Sum( if(Branch='Pune',Sales)) as value

C:\Users\pdontham\Desktop\ScheduledvsOffCycleReleases.xlsx

(ooxml, embedded labels, table is Sheet1)

Group By Empno, Empname, Deptno,Branch, Sales

;

Note: This would give an error free execution, however, I guess not a very meaningful aggregation though.

Re: Invalid expression error in script while reload data

Anonymous — Mon, 06 Feb 2017 06:13:49 GMT

Thanks for your reply.

Can I put sales in group by condition?

Thanks,

Raj

Re: Invalid expression error in script while reload data

avinashelite — Mon, 06 Feb 2017 06:28:29 GMT

You can, but as tresesco‌ mentioned it would be much meaningful aggregation . Try to remove the Sales column from filed and aggr this will give the results but you could missing the Sales for other regions except Pune

What is your actual requirement ??

Re: Invalid expression error in script while reload data

Anonymous — Mon, 06 Feb 2017 06:30:20 GMT

I need to include sales also ...Can i take above script?

Re: Invalid expression error in script while reload data

avinashelite — Mon, 06 Feb 2017 06:43:01 GMT

You can but sum(Sales) would be same as Sales does not give the result what you needed ...

Try like this

Tab1:

Load Empno,

Empname,

Deptno,

Branch,

Sales,

if(Branch='Pune',Sum(Sales) as value

C:\Users\pdontham\Desktop\ScheduledvsOffCycleReleases.xlsx

(ooxml, embedded labels, table is Sheet1);

Temp:

Noconcatenate

Load Empno,

Empname,

Deptno,

Branch,

Sum( if(Branch='Pune',Sales)) as value

C:\Users\pdontham\Desktop\ScheduledvsOffCycleReleases.xlsx

(ooxml, embedded labels, table is Sheet1)

Group By Empno, Empname, Deptno,Branch;

JOIN(Tab1)

LOAD

Empno,

Empname,

Deptno,

Branch,

value

resident

Temp;

Drop table Temp;