Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Alternative Dimension

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
Highlighted
Partner
Partner

Re: Alternative Dimension

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

Highlighted
Partner
Partner

Re: Alternative Dimension

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

Highlighted
Partner
Partner

Re: Alternative Dimension

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.