topic Re: Sort value in Block chart in QlikView

Sort value in Block chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have a block chart like this

I used calculated dimension:

=if(CountOfExpiryDate>180,'>6 Months',if(CountOfExpiryDate>60 and CountOfExpiryDate<181,'2 to 6 Months',if(CountOfExpiryDate<61 and CountOfExpiryDate>0,'<2 Months','Expired')))

Expression is Count(EmployeeID)

CountOfExpiryDate is consists of date count

But there is a problem I need to show the chart like below chart, The value should be show in sort in ascending order ,and how can I sort the value in a block chart

Regards,

Vijay.M

Re: Sort value in Block chart

sunny_talwar — Wed, 15 Mar 2017 14:17:10 GMT

May be like this

if(CountOfExpiryDate>180, Dual('>6 Months', 1),

if(CountOfExpiryDate>60 and CountOfExpiryDate<181, Dual('2 to 6 Months', 2),

if(CountOfExpiryDate<61 and CountOfExpiryDate>0, Dual('<2 Months', 3),

Dual('Expired', 4))))

Re: Sort value in Block chart

Anonymous — Wed, 15 Mar 2017 14:24:13 GMT

Sorry Sunny, its not working which you given condition,may i know is any other condition like this.

Re: Sort value in Block chart

sunny_talwar — Wed, 15 Mar 2017 14:24:55 GMT

Did you use the above as your calculated dimension?

Re: Sort value in Block chart

Anonymous — Wed, 15 Mar 2017 14:28:21 GMT

yes I have used the above as my calculated dimension.

Re: Sort value in Block chart

sunny_talwar — Wed, 15 Mar 2017 14:35:15 GMT

Would you be able to share your app to look at this?

Re: Sort value in Block chart

Anonymous — Wed, 15 Mar 2017 14:47:40 GMT

Sorry I don't know to share can you guide me

Re: Sort value in Block chart

sunny_talwar — Wed, 15 Mar 2017 14:48:51 GMT

Check these links

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample