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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated dimension in INLINE table!

Hi

I have INLINE table as given below. I want to add one more field in that table. Which Should be calculated like this(=Mid([Forecast Display], 2)). Could you please suggest me how that could be done.


[Chart]:
LOAD * INLINE
[Range
a3.5
a4
a6
a8
a12
];


4 Replies
Not applicable
Author

I have done something like below and it works but it is manual. Still wanted to know is there is any way of doing that with calculated dimension.


[Chart]:
LOAD * INLINE
[Range,Range1
a3.5,3.5
a4,4
a6,6
a8,8
a12,12
];


deepakk
Partner - Specialist III
Partner - Specialist III

hi Attitude,

use function mid and try it out

mid(Fieldname,2, len(filedname))

Not applicable
Author

Thanks Deepak

Yes I know that. But is it possible to do the calculated dimension in a inline table. Please check and let me know!

deepakk
Partner - Specialist III
Partner - Specialist III

hi Attitude,

Below is the code. Instead of load * inline use the field names.

LOAD

F1,mid(F1,2,len(F1)) as tt INLINE

[



F1,

122

33

33

;