Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Create a bar chart with below dimension
1) %time
2) =ValueList('yes','no','whatever')
Create below measure
=Pick(match(ValueList('yes','no','whatever'),'yes','no','whatever'),
sum(yes),sum(no),sum(whatever))
Go to properties ,Appearance->Presentation -> select "stacked"
In dimensions, select =ValueList('yes','no','whatever') dimension as "stack" and % time dimension as "Bars"
Create a bar chart with below dimension
1) %time
2) =ValueList('yes','no','whatever')
Create below measure
=Pick(match(ValueList('yes','no','whatever'),'yes','no','whatever'),
sum(yes),sum(no),sum(whatever))
Go to properties ,Appearance->Presentation -> select "stacked"
In dimensions, select =ValueList('yes','no','whatever') dimension as "stack" and % time dimension as "Bars"
New to Qliksense, Worked as expected. Thanks a lot!!
But it messed up at the sorting. Can you help me with sorting, I want to do the sorting by the %time in asc 0, 0-25, 25-50,50-75,75-100,100
@rammiee93 you can either create sort weight from script with dual function like below
LOAD if(%time = 0,dual ('0%',1), if(%time = '0%-25%',dual ('0%-25%',2),.....)))) as %time
Now call this in dimension which you can sort it Numeric ascending or descending
or you can use match function in Expression sorting option in chart
=match(only({1}%time),'0%','0%-25%',....)