Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Inline months

I have a table AAA source which has field  month as JN, Fb, MR , how do i load inline to show January , February and linked to that field  

2 Replies
Highlighted
Support
Support

Re: Inline months

HI,

You can add an inline table

 

LOAD * INLINE [
AAA, Months
JN, January
FB, February
MR, March
];

 

Bill

Bill - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Highlighted
Partner
Partner

Re: Inline months

 I support @Bill_Britt  proposal using an inline, but I would probably create the Month value as an dual() to assure a better sort order of the field in my application.

Months:
LOAD 
   AAA,  
   DUAL(Month, No) as Month
INLINE [
   AAA, Month, No
   JN, January, 1
   FB, February,2
   MR, March,3
   AP, April, 4
   ...
];

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes