Solved: Re: % of participation in more than 1 segmentation - Qlik Community

Report Inappropriate Content · ‎2014-03-19

Hey guys!

I need to create a table with products and their billing participation in the global results. Furthermore, I need to show in the same table, in other column the billing participation of each product in your segment, in your category and in your sector. Finaly, I need to show the billing participation of these product by brand.

Example:

The sales of the Product A represents:

x% of the Global Billing;

x% of the its Sector Billing;

x% of the its Segment Billing;

x% of the its Category Billing;

x% of the Billing of your Brand.

Could you please help me?

MK_QSL · ‎2014-03-20

Like this?

UPDATE : Use new updated file... 2nd table at bottom..

View solution in original post

MK_QSL · ‎2014-03-19

Something like this.. if not, let us have your sample data file..

Global Billing

SUM({<Product = {'A'}>}Sales)/SUM({1}Sales)

Sector Billing

SUM({<Product = {'A'}>}Sales)/SUM({1}<Sector>Sales)

Segment Billing

SUM({<Product = {'A'}>}Sales)/SUM({1}<Segment>Sales)

Category Billing

SUM({<Product = {'A'}>}Sales)/SUM({1}<Category>Sales)

Brand Billing

SUM({<Product = {'A'}>}Sales)/SUM({1}<Brand>Sales)

Report Inappropriate Content · ‎2014-03-19

Thanks for the answer Manish, but I need to show in the same table 30.000 products and its respectives participations on its categories, sectors, brands and segments.

Each product is included in a determinate category. The same thing to the others segmentations.

I have 30.000 products, 12 sectors, 45 segments, 588 categories and 3.000 brands.

Understand?

De: Manish Kachhia

Enviada em: quarta-feira, 19 de março de 2014 16:58

Para: Alexandre Bernardes

Assunto: Re: - % of participation in more than 1 segmentation

<http://community.qlik.com/> Qlik Community

% of participation in more than 1 segmentation

reply from Manish Kachhia <http://community.qlik.com/people/MRKachhiaIMP?et=watches.email.thread> in New to QlikView - View the full discussion <http://community.qlik.com/message/491269?et=watches.email.thread#491269>

MK_QSL · ‎2014-03-19

Can you provide sample data.. i.e 5 from each group....?

Report Inappropriate Content · ‎2014-03-20

Let me show you in a Excel table what I need:

DATA

PRODUCTS

SALES

BRANDS

SECTORS

SEGMENTS

CATEGORIES

A

11%

33%

57%

100%

B

8%

25%

43%

100%

C

14%

42%

100%

33%

D

27%

100%

67%

E

22%

100%

53%

100%

53%

F

14%

71%

33%

71%

33%

G

5%

29%

13%

29%

13%

TOTAL

100%

The product A have 11% of representation in the global bill, 33% of representation on its brand (Burger King), 57% of participation in its sector (Food), 100% on its segment ( FastFood) and 100% on its category (Hamburger).

I need a table with all these participations for each product, on its each segmentation.

De: Manish Kachhia

Enviada em: quarta-feira, 19 de março de 2014 17:56

Para: Alexandre Bernardes

Assunto: Re: - % of participation in more than 1 segmentation

<http://community.qlik.com/> Qlik Community

% of participation in more than 1 segmentation

reply from Manish Kachhia <http://community.qlik.com/people/MRKachhiaIMP?et=watches.email.thread> in New to QlikView - View the full discussion <http://community.qlik.com/message/491275?et=watches.email.thread#491275>

MK_QSL · ‎2014-03-20

Like this?

UPDATE : Use new updated file... 2nd table at bottom..

Report Inappropriate Content · ‎2014-03-20

EXCELENT!!!!

YOU´RE PERFECT!!!

MK_QSL · ‎2014-03-20

My first answer was also looks ok.. you just have to remove...

{<Product = {'A'}>}Sales)

Report Inappropriate Content · ‎2014-03-20

Perfect. I´m trying to do the same things here in my database.

Let me see if it will be OK...