topic Re: Month's Alpha vs Calendar order in QlikView

Month's Alpha vs Calendar order

Wed, 22 Jun 2011 12:34:10 GMT

I have a chart that i added text to that shows the months the user is looking at. The trouble is that the Months come out in Alphabetical order. I want to see them in the order they are on the calendar. I have tryed everything i know and i cannot get this to work.

Any direction would be greatly appreciated

Thanks

Karen

Month's Alpha vs Calendar order

Wed, 22 Jun 2011 12:51:41 GMT

Hi, Use Dual() Function to make to calendar order. Expression Should be something like below.

=Dual(Expression_With_Month,Month)

-Sridhar

Re: Month's Alpha vs Calendar order

Wed, 22 Jun 2011 13:14:44 GMT

I don't mean to be dense...I am new to this...

=if ( count ( distinct GraphData.GMonth) = count( distinct

GraphData.GMonth), 'YTD', if ( count ( distinct GraphData.GMonth) ,

concat ( distinct GraphData.GMonth, ', ' ) ))

This is the expression I am using and I am unfamiliar with a dual

expression...where do I put the dual? At the beginning or instead of

the concat? Or somewhere else altogether?

Karen

Month's Alpha vs Calendar order

Wed, 22 Jun 2011 13:45:38 GMT

Should be some thing like this.

Dual(

if ( count ( distinct GraphData.GMonth) = count( distinct

GraphData.GMonth), 'YTD', if ( count ( distinct GraphData.GMonth) ,

concat ( distinct GraphData.GMonth, ', ' ) ))

, GraphData.GMonth)

EDIT:(untested Expression)

-Sridhar