topic Re: Sorting issue in bar chart in QlikView

Sorting issue in bar chart

deepakqlikview_123 — Wed, 22 Jul 2015 04:18:02 GMT

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

Re: Sorting issue in bar chart

Anonymous — Wed, 22 Jul 2015 04:33:45 GMT

Hi Tibhe,

try using this function in calculated dimension

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

hope it will help

Regards,

Suryanto

Re: Sorting issue in bar chart

krishna20 — Wed, 22 Jul 2015 06:39:05 GMT

Hi,

Is this your requirement?

Re: Sorting issue in bar chart

sasiparupudi1 — Wed, 22 Jul 2015 06:55:32 GMT

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

Re: Sorting issue in bar chart

Wed, 22 Jul 2015 07:09:03 GMT

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.

Re: Sorting issue in bar chart

Wed, 22 Jul 2015 07:34:07 GMT

Hi,

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

Thanks!

Re: Sorting issue in bar chart

Anonymous — Wed, 22 Jul 2015 07:46:07 GMT

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

Re: Sorting issue in bar chart

deepakqlikview_123 — Wed, 22 Jul 2015 14:30:57 GMT

Hi Suryanto,

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

thanks