topic Re: delimiter in script in QlikView

delimiter in script

pandiarajan — Tue, 20 May 2014 08:18:24 GMT

Dear friends,

My Original Table

Branch Employees

Agra aaa|aaa|bbb|CCC

Patna AAA|ccc

Result Shoul Be

Branch Employees

Agra aaa

Agra bbb

Agra CCC

Patna AAA

Patna ccc

if i was use subfield

Branch Employees

Agra aaa

Agra bbb

Agra CCC

Patna AAA

Patna ccc

but i need

Branch Employees

Agra aaa

Agra bbb

Agra CCC

Patna AAA

Patna ccc

please help me someone

Re: delimiter in script

MayilVahanan — Tue, 20 May 2014 08:23:02 GMT

Try like this

Load SubField(Employees,'|') As Employess, Branch;

LOAD * INLINE [

Branch,Employees

Agra, aaa|aaa|bbb|CCC

Patna,AAA|ccc

];

And in chart

Branch, Employees as dimension

count(Employees) as exp

You can see the "2" count for aaa..

You can see the values in table viewer.

Re: delimiter in script

Tue, 20 May 2014 08:23:11 GMT

Attached - include rowno()

Re: delimiter in script

tresB — Tue, 20 May 2014 08:25:14 GMT

SubField would give you that. May be you are getting confused in the front-end, because table box shows unique records. rather check frequency in list box. See attached.

Re: delimiter in script

whiteline — Tue, 20 May 2014 08:27:08 GMT

Hi.

The subfield function works as supposed.

I guess you check the data with the table box. It shows only unique combinations, so you just don't see that there are two records in the table.

Open the table view to check it or use chart straight table instead of table box.