topic Re: Aggregations in script without Resident in QlikView

Aggregations in script without Resident

Wed, 01 Jun 2016 13:40:18 GMT

Hi,

I want to create a simple a aggregation like Count in the script,

but i can't use resident, is it possible?

the table looks like that:

Load item_code

store_code

From [..\Qvd\Fact_Current_Prices](qvd);

I need to count the number of items for each store,

i have to do it in the script and without using resident (though it's working with resident)

Thanks.

Re: Aggregations in script without Resident

andrespa — Wed, 01 Jun 2016 15:49:35 GMT

Hi Roman, why you don't do it in the same table, like this:

Load

item_code

count(item_code) as No_items,

store_code

From [..\Qvd\Fact_Current_Prices](qvd)

group by

item_code,

store_code;

Re: Aggregations in script without Resident

marcus_sommer — Wed, 01 Jun 2016 16:08:01 GMT

Shouldn't it not more look like?

Load

item_code,

count(item_code) as No_items,

store_code

From [..\Qvd\Fact_Current_Prices](qvd)

group by

item_code,

store_code;

This meant without item_code unless within the aggregation.

- Marcus