Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Count total sales

The customer wants me to count all the sales that has an especific type of item. For example:

Table: ITEMS, this are the items that the customer sales.

ItemCodTypeItem
AA10001
AA90001
AC60003
PA33302

TABLA: TypeItem, this are the cateroies of the items

CodTypeItemDesTypeItem
01

FOOD

02DRINKS
03OTHER

TABLA: Sales,

IDClienDateTotal
1Coca20161210555
2Pepsi201612112156
3Pepsico20161213100

TABLA: SalesDet, sales detail.

IDITEMTOTAL
1AA1001326
1PA333200
2AA100100
3AC600667

The customers wants a table like this

TypeNumer of salesavg amount per sale
Food2500
drink3123
other6900
Tags (3)
2 Replies
vinieme12
Esteemed Contributor II

Re: Count total sales

Check the attached app

Not applicable

Re: Count total sales

I already found a way to do it. Thank you very much!

Community Browser