# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Creator

## Sort a chart by dimension

Hello,

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.

Best regards,

Patrick

2 Solutions

Accepted Solutions
Highlighted
MVP

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)))))))

Highlighted
MVP

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))))))
4 Replies
Highlighted
MVP

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)))))))

Highlighted
MVP

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

@sunny_talwar@tresesco - Will that New Community, Will make changes the flag? Seems, You and Sunny together got Correct Answer?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
MVP

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.