Data in a pivot table dimension

[beginner_44]

Hi! 

I have a pivot table with dimensions: type, name, code, product. If the company's turnover at the time set by the user is greater than 10,000€, then in the pivot table I write "Group 1" in the dimension type and show name, code, product. If the company's turnover at the time set by the user is less than €10,000, then in the pivot table dimension type I write "Group 0" and only show the turnover. If a customer with type "Group 1" sells several products, the product does not appear in the view, why?  If a customer with type "Group 1" sells one product, the product is also visible in the view. I can't see Company 1 products, product 1 and product 3, why?

Type	Name	Code	Product	Turnover
Group 1	Company 1	10156	Product 1	5 000
Group 1	Company 1	10156	Product 3	12 000
Group 1	Company 2	66305	Product 7	23 000
Group 2				7 500

[Vegar]

I read through your question, but did not completely understand. Can you please provide some more details?

Is the table above your input data? And you have issues presenting it in the pivot table in QlikView? Or is the table above your output in a QlikView pivot table? If that is the case, then how does your source data look like? What are the expressions you try to use.

Could you provide some screenshots or (even better) a demo-application based on the data you are referring to in your question above? That would be of help.

[beginner_44]

I have attached a sample file. For example, 2024-07 is not product 3 of company 1.

[Kushal_Chawda]

@beginner_44  see the attached

[beginner_44]

 It's not quite what I need. If the type is "Group 2", the name, code and product do not need to be shown.

[Kushal_Chawda]

@beginner_44  In your qv app, for group 2, the name, product and code is not showing, so what exactly do you want to do? Could you please give examples?

[beginner_44]

@Kushal_Chawdathe correct result is

Type	Name	Code	Product	Turnover
Group 1	Company 1	10156	Product 3	16000
Group 1	Company 1	10156	Product 1	1250
Group 1	Company 2	66305	Product 7	11500
Group 2				20
Total				28770

[Kushal_Chawda · Accepted solution]

@beginner_44  see the attached

[beginner_44]

@Kushal_Chawda  exactly what I need, thanks!!!

[Kushal_Chawda]

@beginner_44  Please accept the solution to close this thread