topic Re: Data in a pivot table dimension in QlikView

Data in a pivot table dimension

beginner_44 — Thu, 15 Aug 2024 06:52:28 GMT

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

Re: Data in a pivot table dimension

Vegar — Thu, 15 Aug 2024 07:13:16 GMT

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.

Re: Data in a pivot table dimension

beginner_44 — Thu, 15 Aug 2024 10:22:00 GMT

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

Re: Data in a pivot table dimension

Kushal_Chawda — Thu, 15 Aug 2024 11:03:00 GMT

@beginner_44 see the attached

Re: Data in a pivot table dimension

beginner_44 — Thu, 15 Aug 2024 11:35:37 GMT

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

Re: Data in a pivot table dimension

Kushal_Chawda — Thu, 15 Aug 2024 11:49:03 GMT

@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?

Re: Data in a pivot table dimension

beginner_44 — Thu, 15 Aug 2024 12:04:05 GMT

@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

Re: Data in a pivot table dimension

Kushal_Chawda — Thu, 15 Aug 2024 12:42:17 GMT

@beginner_44 see the attached

Re: Data in a pivot table dimension

beginner_44 — Thu, 15 Aug 2024 13:31:51 GMT

@Kushal_Chawda exactly what I need, thanks!!!

Re: Data in a pivot table dimension

Kushal_Chawda — Thu, 15 Aug 2024 13:49:26 GMT

@beginner_44 Please accept the solution to close this thread