topic Calculated dimension in INLINE table! in QlikView

Calculated dimension in INLINE table!

Thu, 03 Mar 2011 08:16:45 GMT

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
];

Calculated dimension in INLINE table!

Thu, 03 Mar 2011 08:25:57 GMT

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
];

Calculated dimension in INLINE table!

deepakk — Thu, 03 Mar 2011 08:29:36 GMT

hi Attitude,

use function mid and try it out

mid(Fieldname,2, len(filedname))

Calculated dimension in INLINE table!

Thu, 03 Mar 2011 08:33:15 GMT

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!

Calculated dimension in INLINE table!

deepakk — Thu, 03 Mar 2011 08:41:14 GMT

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

;