Qlik Community

Qlik Sense App Development

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

Highlighted
everest226
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
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
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.
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
   ...
];

 

#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.