Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Month's Alpha vs Calendar order

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

Labels (1)
3 Replies
Not applicable
Author

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

      =Dual(Expression_With_Month,Month)

-Sridhar

Not applicable
Author

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

Not applicable
Author

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