Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
Not applicable

Aggr + Set Analysis in Product's Stock Calculation

Hi!

I'm working on a report wich should show stock information.

It contains Information about Stores, Price Range, and a Grouping attribute based on the product category.

The idea is that you can input how many units of a Product you need to send to a Store.

One of the aggregations i'm trying to calculates is the total of products Aggregated by Category, Store and PriceRange.

The problem is that it only works properly when I select a Store. When there are no Selections, it doesn't show the right numbers.

I'm using the next expression (as I need it to repeat the aggregated stock values in every row):

aggr(nodistinct max(TOTAL STOCK), CATEGORY, STORE, PRICE RANGE) + Aggr(nodistinct InputSum(SEND), CATEGORY, STORE, PRICE RANGE).

Thanks in advance!

Agustín.-

1 Reply
Partner
Partner

Re: Aggr + Set Analysis in Product's Stock Calculation

Try:

- put a set analysis in the expression STORE=:

aggr(nodistinct max({<STORE=>} TOTAL STOCK), CATEGORY, STORE, PRICE RANGE) + Aggr(nodistinct InputSum({<STORE=>} SEND), CATEGORY, STORE, PRICE RANGE)