Skip to main content

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
merry2018
Creator III
Creator III

different selections in one list, side by side on one worksheet

Hello Together, 

I need your help again. 

For my actually Projekt I sould put one Diagram three times on a worksheet, and for each I will a List for selection. They Tablediagrams get the same Data and the Lists as well, so that we can compare 3 different pack of Data. 

For Example It sould look like this:

Selectionsliste: 

Teile

VarianteA
VarianteB
VarianteC
VarianteD
VarianteE
VarianteF

 

Teile Werte mit Summe: 69
VarianteA 20
VarianteB 15
VarianteC 34

____________________________________________________________________________________________________

Selectionsliste: 

Teile

VarianteA
VarianteB
VarianteC
VarianteD
VarianteE
VarianteF

 

Teile Werte mit Summe: 45
VarianteA 20
VarianteE 17
VarianteF 8

____________________________________________________________________________________________________

Selectionsliste: 

Teile

VarianteA
VarianteB
VarianteC
VarianteD
VarianteE
VarianteF

 

Teile Werte mit Summe: 57
VarianteD 25
VarianteB 15
VarianteE 17

 

They three pairs (Table with list) would like to be side by side, that we can compare the Parts.

 

I thought it will be done with Set Analyse, but I can not found how, did anyone know a idea how i get it?

 

Regards 
Merry

Labels (1)
1 Solution

Accepted Solutions
Andrei_Cusnir
Support
Support

Hello,

 

If my understanding is correct, you have one dataset and you would like to filter different values on 3 different tables on the same sheet to compare selections. These are the steps that I have followed to achieve a similar outcome:

 

1. Created 3 Filter panes and 3 Table charts with the data:

IMAGE

 

2. If you apply one selection to the first Filter pane, the selection will be applied to all the other visualizations as well:

IMAGE

 

3. What you need here, is NOT Set Analysis but States. Create 3 states:

IMAGE

 

4. Go to each visualization and assign the corresponding state:

 

First Filter pane and Table chart:

  • Filter pane =>  Appearance > Alternative states > State and set it to "State A"
  • Table chart =>  Appearance > Alternative states > State and set it to "State A"

Second Filter pane and Table chart:

  • Filter pane =>  Appearance > Alternative states > State and set it to "State B"
  • Table chart =>  Appearance > Alternative states > State and set it to "State B"

Third Filter pane and Table chart:

  • Filter pane =>  Appearance > Alternative states > State and set it to "State C"
  • Table chart =>  Appearance > Alternative states > State and set it to "State C"

5. Now you can apply different selections to the Filter panes and the Table charts will display different data:

IMAGE

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members. 
 

 

 

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

2 Replies
Andrei_Cusnir
Support
Support

Hello,

 

If my understanding is correct, you have one dataset and you would like to filter different values on 3 different tables on the same sheet to compare selections. These are the steps that I have followed to achieve a similar outcome:

 

1. Created 3 Filter panes and 3 Table charts with the data:

IMAGE

 

2. If you apply one selection to the first Filter pane, the selection will be applied to all the other visualizations as well:

IMAGE

 

3. What you need here, is NOT Set Analysis but States. Create 3 states:

IMAGE

 

4. Go to each visualization and assign the corresponding state:

 

First Filter pane and Table chart:

  • Filter pane =>  Appearance > Alternative states > State and set it to "State A"
  • Table chart =>  Appearance > Alternative states > State and set it to "State A"

Second Filter pane and Table chart:

  • Filter pane =>  Appearance > Alternative states > State and set it to "State B"
  • Table chart =>  Appearance > Alternative states > State and set it to "State B"

Third Filter pane and Table chart:

  • Filter pane =>  Appearance > Alternative states > State and set it to "State C"
  • Table chart =>  Appearance > Alternative states > State and set it to "State C"

5. Now you can apply different selections to the Filter panes and the Table charts will display different data:

IMAGE

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members. 
 

 

 

Help users find answers! Don't forget to mark a solution that worked for you! 🙂
merry2018
Creator III
Creator III
Author

Thank you, that is exactly what I need.