Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
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.

Thank you for your help.

Best regards,

Patrick

2 Solutions

Accepted Solutions
Highlighted
MVP
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)))))))

View solution in original post

Highlighted

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

View solution in original post

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

View solution in original post

Highlighted

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

View solution in original post

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

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.