Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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
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:
result (per analogy):
Hope this helps !
Omar BEN SALEM.