Alternate Dimensions in Pivot or Simple Table

[ronman10]

Hi Everyone,

I am trying to find a way to add alternative dimensions in a pivot table or a simple table, the same way we have in bar, line chart etc. What I am looking for is a dropdown list with all the dimensions in it. When I click on a particular dimension, the dimension part of the table must get replaced accordingly and the data should change as per the dimension applied. Please let me know how I can achieve this?

Best Regards,

Rony

[ronman10]

No change happens to the table in the master visualization even after dropping it to the climber extension, as shown in the image above.

[Gysbert_Wassenaar]

Did you choose Replace instead of Add? You should choose to Add the table.

[ronman10]

This is the only option I am getting. The table in the master visualization can be any table right?

[Gysbert_Wassenaar]

Which version of Qlik Sense are you using?

[ronman10]

Hi Gysbert,

The master visualization that I created was using a vizlib table. I just tried the same using a simple table available by default in qlik sense and it seems to be working now. Looks like it does not read an extension table.

I am using June 2018 QS.

Rony

[Gysbert_Wassenaar]

Makes sense. Glad you got it sorted.

[ronman10]

It is working fine now. Thanks for your help Gysbert.

Regards,

Rony

[robert99]

Hi Ron

Step 1. Step up list in script as follows

Step 2. Set up a filter pane and table (Pivot table)in a sheet

Step three. Add columns > dimension or measures to table or pivot table

Step 4. Link the dimension or measures to the filter pane

IF(WildMatch(GetFieldSelections(xReportType),'*CustName*'),1,0)

[ronman10]

Hi Robert,

Thank you for the detailed explanation. I will try this.

Best Regards,

Rony