Qlik Community

Qlik Sense App Development

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

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor 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