Discussion board where members can get started with QlikView.
can anybody please help me with arranging all the months in a list box. The month value is picking from an excel sheet. I need the list box to steady in the Jan - Dec order. Sample also attached.
Go to Solution.
use an inline load in the beginning of the load script (after variables). give it the same field name, then drop at the end of the script. once reloaded, change the sort order to 'Load Order'
load * inline [
Add the following to your Load Statement
MONTH_VIEW:LOAD * INLINE [[Approved Month], MONTH_INDEXJanuary, 01February, 02March, 03April, 04May, 05June, 06July, 07August, 08September, 09October, 10November, 11December, 12];
Then sort by Month_index in your list