topic Re: Sort a chart by dimension in QlikView

Sort a chart by dimension

patrou38 — Wed, 14 Nov 2018 10:50:15 GMT

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

Re: Sort a chart by dimension

tresB — Wed, 14 Nov 2018 11:26:11 GMT

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

Re: Sort a chart by dimension

sunny_talwar — Wed, 14 Nov 2018 12:19:11 GMT

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

Re: Sort a chart by dimension

Anil_Babu_Samineni — Wed, 14 Nov 2018 13:50:40 GMT

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

Re: Sort a chart by dimension

sunny_talwar — Wed, 14 Nov 2018 14:06:30 GMT

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.