Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Alternative Dimension

Hi Community,

I want to add alternative dimension to straight table like we add alternative dimensions to charts. Is there any way to change straight table values based on dimension in qlik sense?

test1.png

1 Solution

Accepted Solutions
shraddha_g
Partner - Master III
Partner - Master III

Alternate Dimension wont work in Simple Table.

Try using a Extension (https://www.quickintelligence.co.uk/toggle-buttons-qlik-sense/ or Makes Sense to go round in circles)

These both tutorials will help you to change dimension in chart using Variables.. It will look like a Alternate Dimension

View solution in original post

3 Replies
shraddha_g
Partner - Master III
Partner - Master III

Alternate Dimension wont work in Simple Table.

Try using a Extension (https://www.quickintelligence.co.uk/toggle-buttons-qlik-sense/ or Makes Sense to go round in circles)

These both tutorials will help you to change dimension in chart using Variables.. It will look like a Alternate Dimension

prithviram777
Partner - Contributor III
Partner - Contributor III

Hi Aparna,

You cannot add alternate dimensions to straight tables, instead you can try using Pivot table and expand the year you want.

Hope it helps.

Thanks

OmarBenSalem

Suppose you have 2 dimension : Name and Post

and u want to have a choice to show one of them (or maybe both)

do as follow:

create an inline table in ur script:

Load * inline [

DimensionID, Dimension

1, NAME

2, POST

];

Now add this new Dimension as a filter above ur table.

And within ur table, as a dimension create:

if(DimensionID=1,Name, Post)

for Its label : Dimension

and now you have a sort of 'alternative dimensions' in ur straight table.

Please, download this extension:

https://github.com/countnazgul/Qlik-Sense-Styled-Lists-Extension

and use it as a filter for ur newly created Dimension.

In the option do as follow to force a selection of only one value and have a by default selected value:

Capture.PNG

result (per analogy):

Capture.PNG

Capture.PNG

Hope this helps !

Omar BEN SALEM.