Discussion Board for collaboration on QlikView Scripting.
My Original Table
Result Shoul Be
if i was use subfield
but i need
please help me someone
Go to Solution.
Try like this
Load SubField(Employees,'|') As Employess, Branch;
LOAD * INLINE [
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.
Attached - include rowno()
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.
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.