Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Aggregations in script without Resident

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.

1 Solution

Accepted Solutions

Re: Aggregations in script without Resident

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

2 Replies
andrespa
Valued Contributor

Re: Aggregations in script without Resident

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

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

Community Browser