topic Re: Resident load problem in QlikView

Resident load problem

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

Hi,

I am going to use the following query with resident load, but it gives me syntax error for the following load statement;

[207 Mutual Funds Retail]:

Load "Sales Key",

Sum("SalesUSD") as "Mutual Funds"

Resident [Temp Table 5]

Where "Trans Trade Class" ='S' and ("Product Type" !='DE' or "Product Type"!='PA');

in Sql I have a query like this:

Select sum(Sales) from table 1 where

("Product Type"<>'DE' or "Product Type"<>'PA' or "Product Type"<>'RE' or "Product Type"<>'SA' or "Product Type"<>'CE'

or "Product Type"<>'AA' or "Product Type"<>'VA' or "Product Type"<>'5M' or "Product Type"<>'FA') ;

Thanks,

Sandip

Re: Resident load problem

stabben23 — Fri, 07 Apr 2017 11:24:01 GMT

Hi,

You have forgot to use Group by, this is needed when you use aggregation in script.

Load "Sales Key",

Sum("SalesUSD") as "Mutual Funds"

Resident [Temp Table 5]

Where "Trans Trade Class" ='S' and ("Product Type" !='DE' or "Product Type"!='PA')

Group by "Sales Key";

Re: Resident load problem

beck_bakytbek — Fri, 07 Apr 2017 11:25:08 GMT

Hi Sandip

try this:

[207 Mutual Funds Retail]:

Load "Sales Key",

Sum("SalesUSD") as "Mutual Funds"

Resident [Temp Table 5]

Where "Trans Trade Class" ='S' and ("Product Type" !='DE' or "Product Type"!='PA')

Group by "Sales Key";

Re: Resident load problem

MK_QSL — Fri, 07 Apr 2017 11:25:09 GMT

What error are you getting?

try below

("Product Type" <>'DE' or "Product Type"<> 'PA')

Group by "Sales Key";

Re: Resident load problem

stabben23 — Fri, 07 Apr 2017 11:25:38 GMT

You should also change Your Not valid to !=, use <> instead

Re: Resident load problem

rahulpawarb — Fri, 07 Apr 2017 12:17:31 GMT

Hello Sandip,

You can make use of below given sample script:

[207 Mutual Funds Retail]:
Load [Sales Key],
Sum(SalesUSD) as [Mutual Funds]
Resident [Temp Table 5]
Where  [Trans Trade Class] ='S' and Not Match([Product Type], 'DE', 'PA')
GROUP BY [Sales Key];

Hope this will be helpful.

Regards!

Rahul