Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ruisilvafilipe
Contributor
Contributor

Choose always the highest value

Hello everyone,

I am trying to do a new pivot tables based on the following:

table.png

1) Choose which stream have the highest Volume. Somehow pick the Business stream and discart the Categories

2) For each Number, which is the highest Division and pick the OM Division

3) Then, the highest Unit. In this case, MCM.

If the Categories stream have the highest Volume, then which Category has the hight volume.

 

In the end, I would like to have 2 pivot tables like that:

- That counts how many diferent IDs I have for each Division or Category

Div.png       Cat.png

I am new at qlik and my knowledge does not allow me to achieve this goal!!
 
Thank you in advance.
Labels (3)
0 Replies