Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

qlik_aparnav
Contributor 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
shraddha_g
Honored Contributor III

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

3 Replies
shraddha_g
Honored Contributor III

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

prithviram777
New Contributor III

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

OmarBenSalem
Esteemed Contributor

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.

Community Browser