Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
I have attached a sample file. For example, 2024-07 is not product 3 of company 1.
@beginner_44 see the attached
It's not quite what I need. If the type is "Group 2", the name, code and product do not need to be shown.
@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?
@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 |
@beginner_44 see the attached
@Kushal_Chawda exactly what I need, thanks!!!
@beginner_44 Please accept the solution to close this thread