topic Re: SORT IN BAR CHART FOR INTERVAL in QlikView

SORT IN BAR CHART FOR INTERVAL

manoranjan_d — Tue, 08 Nov 2016 11:06:24 GMT

HI all

LOAD

[user name],

If(Count([login details])>40, '>40' , Replace( Class (Count([login details]),10),'<= x <','-')) as Login

Resident Main

Group By [user name];

in bar chart i have used the login as dimension and count(username) as exprseion

now this dimension has to be in proper sort order of interval form 0 to >4 how to this? i tried but its not working

interval in the coding

Re: SORT IN BAR CHART FOR INTERVAL

its_anandrjs — Tue, 08 Nov 2016 11:14:19 GMT

In the sort option >> select expression >> And write expression there for sorting

Ex:-

This is example

=ONLY(Match(FieldName,'0 - 10',

'10 - 20',

'20 - 30',

'30 - 40'

'>50'))

Regards

Anand

Re: SORT IN BAR CHART FOR INTERVAL

manoranjan_d — Tue, 08 Nov 2016 11:19:33 GMT

its not working pls share some thing

Re: SORT IN BAR CHART FOR INTERVAL

its_anandrjs — Tue, 08 Nov 2016 11:19:53 GMT

Also you can load some sorting table also for the sorting.

Ex:-

Load * Inline

[

[No of times] , [Sort Order]

0 , 1

1-5 , 2

6-10 , 3

11-20 , 4

21-40 , 5

>41 , 6

];

Note:- This [No of times] field is connected with your field which is same due to that you get sort order as [Sort Order]

then use this field in the Sorting option to sort.

Regards

Anand

Re: SORT IN BAR CHART FOR INTERVAL

antoniotiman — Tue, 08 Nov 2016 11:26:36 GMT

In Sort Option > Expression try

Class (Count([login details]),10)

Re: SORT IN BAR CHART FOR INTERVAL

manoranjan_d — Tue, 08 Nov 2016 11:29:52 GMT

SORRY ITS working thanks

Re: SORT IN BAR CHART FOR INTERVAL

its_anandrjs — Tue, 08 Nov 2016 15:12:40 GMT

Great

Thanks if got correct answer then please close the thread by appropriate answer.

Regards

Anand