Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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
suryanto89
Contributor III
Contributor III

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!

suryanto89
Contributor III
Contributor III

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