Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
marcus_sommer

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

View solution in original post

2 Replies
andrespa
Specialist
Specialist

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;

marcus_sommer

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