Discussion Board for collaboration on QlikView Layout & Visualizations.
I need help to sort my chart by the dimension, but on the labal ? is it possible ? any workaround ?
as you can see in my attached exemple this is not very easy.
I would like to have a sort like this:
Day <=3, Day 3-5, Day 5-7, Day 7-10, Day 10-12 and Day sup 12.
Thank you for your help.
You need to modify the expression a bit like:
=if(Day<=3 ,Dual('Day <=3',0),if(Day>=3 and Day<5,dual('Day 3-5',1),if(Day>=5 and Day<7,dual('Day 5-7',2),if(Day>=7 and Day<10,dual('Day 7-10',3),if(Day>=10 and Day<12,dual('Day 10-12',4),if(Day>=12 , Dual('Day sup 12',5)))))))
View solution in original post
You might also want to simplify your if statement by using something like this
=If(Day <= 3, Dual('Day <=3', 0),
If(Day < 5, Dual('Day 3-5',1),
If(Day < 7, Dual('Day 5-7',2),
If(Day < 10, Dual('Day 7-10',3),
If(Day < 12, Dual('Day 10-12',4), Dual('Day sup 12', 5))))))
@sunny_talwar@tresesco - Will that New Community, Will make changes the flag? Seems, You and Sunny together got Correct Answer?
Yes, it appears that multiple responses can be marked as the correct response. It seems to be similar to how Helpful responses used to work in JIVE.