topic sorting bar graph in QlikView

sorting bar graph

Mon, 08 Sep 2014 09:53:12 GMT

Hi all,

i have a bar graph with dimension as 'category' which includes Diamond, Platinum, Gold, Silver and Others

how do i sort them in same order

thanks in advance

Re: sorting bar graph

IAMDV — Mon, 08 Sep 2014 10:11:37 GMT

Hi Deepak,

You can use the Load Order for sorting or you can use the Match function.

Check this video from my blog post:

http://qlikshare.com/622/

I hope this helps!

Cheers,

Re: sorting bar graph

MK_QSL — Mon, 08 Sep 2014 10:12:19 GMT

Load * Inline

[

category, SortOrder

Diamond, 1

Platinum, 2

Gold, 3

Silver, 4

Others, 5

];

Create above Inline Table and go to sort table and add below in expression... Now sort by numeric ascending order

SortOrder

Or 2nd Method:

You can simply write below expression in your sort tab...

=Pick(Match(category,'Diamond','Platinum','Gold','Silver','Others'),1,2,3,4,5)

Re: sorting bar graph

ajaykumar1 — Mon, 08 Sep 2014 10:15:26 GMT

Manish Right applying the inline more easy and you can play some options in the sort tab itself.

Regards,

Ajay

Re: sorting bar graph

qlikoqlik — Mon, 08 Sep 2014 10:20:04 GMT

or you can use an expression using match function in the sort tab

Thanks

Padma

Re: sorting bar graph

Colin-Albert — Mon, 08 Sep 2014 10:38:09 GMT

If you load the categories as a DUAL value, the categories will sort automatically.

Dual(text value, numeric value) - Dual displays the text values but sorts by the numeric values.

Add this to your load script

Load

dual(Category, Pick(Match(Category, 'Diamond', 'Platinum', 'Gold', 'Silver', 'Others') ,1,2,3,4,5 )) as Category,

< the rest of your load script>

Re: sorting bar graph

Mon, 08 Sep 2014 10:44:22 GMT

hi Manish,

I tried the 2nd Method but it didnt work

Re: Re: sorting bar graph

MK_QSL — Mon, 08 Sep 2014 10:47:10 GMT

Check enclosed document...

Re: sorting bar graph

Mon, 08 Sep 2014 10:57:26 GMT

???

Re: sorting bar graph

Colin-Albert — Mon, 08 Sep 2014 10:58:51 GMT

You will have to wait until the moderators release the attachment before you can see it.