topic Re: Sort Bar graph in QlikView

Sort Bar graph

Tue, 06 Dec 2016 11:39:37 GMT

Hi All,

I am trying to sort the bar graph, but i didn't get the way to sort in the below screen shot.

We actually get this based on composite field (Querter and Year).

Need your support.

Thanks

UMAMAHESWRA REDDY

Re: Sort Bar graph

Chanty4u — Tue, 06 Dec 2016 11:47:43 GMT

am not sure,

Try with Match function in sort tab expression:

=match(Field,' value1','value2')

Re: Sort Bar graph

shraddha_g — Tue, 06 Dec 2016 11:49:04 GMT

Use QuarterStart Field or QuarterStart(DateField) in Sort by Expression

Re: Sort Bar graph

sunny_talwar — Tue, 06 Dec 2016 11:57:01 GMT

May be like this:

Date#(KeepChar(Quarter, '0123456789'), 'MYYYY')

Re: Sort Bar graph

ganeshsvm — Tue, 06 Dec 2016 11:57:48 GMT

Best practice is, you should assign PeriodID using Dual() in your Composite field in backend script, This will be useful in sorting & also Date range calculations in the frontend.

something like this,

Dual(Quarter&' '&Year,AutoNumber(Quarter&' '&Year)) as QtrYrPeriod

Regards,

Ganesh

Re: Sort Bar graph

Tue, 06 Dec 2016 12:08:18 GMT

Hi Chanty,

i tried that match, wild match as well, it is giving like below, i need year wise sort then quarter wise sort

Re: Sort Bar graph

shraddha_g — Tue, 06 Dec 2016 12:10:10 GMT

These are dynamic values You cant hardcode using Match()

Re: Sort Bar graph

Tue, 06 Dec 2016 12:12:06 GMT

Hi Sunny,

thanks its working.