Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
vijay26041991
Creator
Creator

Sort value in Block chart

Hi ,

I have a block chart like this

Capture1.PNG

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

new.PNG

Regards,

Vijay.M

7 Replies
sunny_talwar

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))))

vijay26041991
Creator
Creator
Author

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

sunny_talwar

Did you use the above as your calculated dimension?

vijay26041991
Creator
Creator
Author

yes I have used the above as my calculated dimension.

sunny_talwar

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

vijay26041991
Creator
Creator
Author

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