Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
beginner_44
Contributor II
Contributor II

Data in a pivot table dimension

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

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

9 Replies
Vegar
MVP
MVP

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
Contributor II
Contributor II
Author

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
Contributor II
Contributor II
Author

 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
Contributor II
Contributor II
Author

@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

@beginner_44  see the attached

 

beginner_44
Contributor II
Contributor II
Author

@Kushal_Chawda  exactly what I need, thanks!!!

Kushal_Chawda

@beginner_44  Please accept the solution to close this thread