topic Re: Inline Data Representation Issue in QlikView

Inline Data Representation Issue

Fri, 03 Apr 2015 07:43:24 GMT

Dear All,

Is it possible to represent the data in INLINE with space and comma

Ex: Branch name = [Mumbai, Fort]

Thanks in advance

Michiel_QV_Fan — Fri, 03 Apr 2015 07:49:14 GMT

spaces yes but comma no. That is the standard separator.

You can do a load on load and generate the new column as needed:

load City & ','& Other as [New field];

load inline [

City, Other

Mumbai, Fort];

Fri, 03 Apr 2015 07:53:39 GMT

Thanks Michiel for the early reply.

Now i want to implement section access[Field Level] based on Branch .

But my baranch contains the data as mentioned above.

Is it possible to apply section access[Field Level] on Branch?

Michiel_QV_Fan — Fri, 03 Apr 2015 07:58:14 GMT

I do not know. Please run a test.

You also could ask this question in the scripting group instead of New to QlikView.

Anonymous — Fri, 03 Apr 2015 10:08:44 GMT

Works fine with a comma in the data like this :

Data:

LOAD * INLINE [

Dim, Value

'A,kl', 1

B, 1

];