Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Sorting issue in bar chart

PFA.

I want to show

YTD 5 2013 after year 2013 as i am using below calculated dimension.

=if(MONTH=5, 'YTD'& ' ' &MONTH& ' '  &YEAR,if(MONTH=1 or MONTH=12,YEAR))

can you please suggest how shall i go ahead.

thanks

7 Replies
Anonymous
Not applicable

Hi Tibhe,

try using this function in calculated dimension

=if(YEAR>=2013, 'YTD'& ' ' &MONTH& ' '  &YEAR,YEAR)

hope it will help

Regards,

Suryanto

krishna20
Specialist II
Specialist II

Hi,

Is this your requirement?

Help_Comm.png

sasiparupudi1
Master III
Master III

Hi

I do not think it is possible as the dimension is showing the data at the end of each year and may comes before december.

Sasi

Not applicable

Hi Deepak

You can try this :- In Sort Tab

Expression :- Ascending

( match(YEAR,'1995','1996','1997','1998','1999','2000','2001','2002','2003','2004','2005','2006','2007','2008','2009','2010','2011','2012','2013','YTD 5 2013','2014','YTD 5 2014')

)

Text :-

A -> Z



Hope this helps. ( Don't Forget to hit " Correct Answer " Button, if you got your solution )


Regards

Ahmed.

Not applicable

Hi,

PFA - .qvw file. Also find the screenshot. Hope that helps!!

Thanks!

Anonymous
Not applicable

Hi Tibhe,

if it's about the filter problem then, try to change the sorting expression into this one

IF(YEAR<2013, YEAR, IF(YEAR>=2013,MONTH & YEAR))

Regards,

Suryanto

deepakqlikview_123
Specialist
Specialist
Author

Hi Suryanto,

It is working as per requirement can you please suggest how to make this synamically when same conditions occurs in future.

thanks