topic Re: Re: chart x- axis sorting in QlikView

chart x- axis sorting

Thu, 05 Jun 2014 12:02:27 GMT

Hi All,

I'm having a chart in attached qlikview file. I want to sort x-axis values as follows

OOC,

1 month,

2 to 3 months

4 to 6 months

>12 months.

I think I have to write some condition under sort tab but I'm not getting which condition to write there.

I tried with sum(bucket), count(bucket). But they are not giving required result. So please help me sort x-axis in the way I have explained above.

Thanks a lot!!!

Re: chart x- axis sorting

Thu, 05 Jun 2014 12:16:39 GMT

use match function as an expression in the sort tab of the chart properties

match(Month, '4 to 6 months','2 to 3 months','1 to 2 months','1 Month')

Thanks and Regards

Padma

Re: chart x- axis sorting

Thu, 05 Jun 2014 12:19:01 GMT

Hi Padma,

Thanks for the reply.

What is Month in above expression??

In my case I'm having "bucket" column using which following text values are assigned. And then that is used as dimension in chart.

OOC,

1 month,

2 to 3 months

4 to 6 months

>12 months.

Re: chart x- axis sorting

alexandros17 — Thu, 05 Jun 2014 12:22:12 GMT

Go in sort tab and take a look

Re: chart x- axis sorting

Thu, 05 Jun 2014 12:25:40 GMT

In this case 'month' is not a dimension. The buckets are calculated dimensions that the OP created

Re: chart x- axis sorting

Thu, 05 Jun 2014 12:25:44 GMT

Hi Alexandros17

Thanks for the reply.

I my case I think I have to work with BUCKET column values instead of its sum. Because the order in which the values need to be displayed is as below and it remains the same irrespective of whatever is sum(BUCKET) value.

OOC,

1 month,

2 to 3 months

4 to 6 months

>12 months.

Re: chart x- axis sorting

Thu, 05 Jun 2014 12:25:45 GMT

Hi,

I used the dual function in your calculated dimension to get the solution.

See attached example.

Re: chart x- axis sorting

Thu, 05 Jun 2014 12:26:13 GMT

I feel instead of creating calculated dimension it's better to create an another field in the script itself. So that you can create an order by defining the order in another flag filed or you can use load order to sort.

Re: chart x- axis sorting

Thu, 05 Jun 2014 12:26:28 GMT

Hi Kavita

Month is whatever dimension or expression you would like to sort

Thanks and regards

Padma

Re: Re: chart x- axis sorting

jonathandienst — Thu, 05 Jun 2014 12:27:03 GMT

See attached. Used duals in the calculated dimension

if(BUCKET<0, Dual('OOC', 0),

if(BUCKET=1, Dual('1 month', 1),

if(BUCKET=2 or BUCKET=3, Dual('2 to 3 months', 2),

if(BUCKET=4 or BUCKET=5 or BUCKET=6, Dual('4 to 6 months', 4),

if(BUCKET=7 or BUCKET=8 or BUCKET=9 or BUCKET=10 or BUCKET=11 or BUCKET=12, Dual('7 to 12 months', 7),

Dual('>12 months', 12)

)))))

HTH

Jonathan

Re: chart x- axis sorting

alexandros17 — Thu, 05 Jun 2014 12:28:32 GMT

... I think this is a mistake unless you use an aggregation function ...

Re: chart x- axis sorting

Thu, 05 Jun 2014 12:31:00 GMT

Why?

Re: chart x- axis sorting

alexandros17 — Thu, 05 Jun 2014 12:36:12 GMT

There are multiple rows with same values, when you write bucket which value (and row) satisfy the condition?

Re: chart x- axis sorting

Thu, 05 Jun 2014 12:41:51 GMT

I agree, this would be ideal.

Re: chart x- axis sorting

Thu, 05 Jun 2014 12:56:13 GMT

Thanks a lot Jacob

Re: chart x- axis sorting

Thu, 05 Jun 2014 12:59:20 GMT

Hi Krupasagar ,

Yes this is a better way to do it.

Re: chart x- axis sorting

Thu, 05 Jun 2014 13:00:07 GMT

No problem homie