Discussion Board for collaboration on QlikView Scripting.
I want to convert the Table1 into Table2 , as given below. This needs to create fields dynamically in Table2 based on the counts of 'Code' aggr. by 'Date' in Table1.
Does anyone have any idea to implement this..
Go to Solution.
See attached qvw
See the attached example.
thanks for you help. Here the important point to be noted is that the no. of fields in Table2 depends on the max. no. of count of code per day.
in the above example,at any day if i get max. count of codes per day is 6 then fields F1,F2...F6 need to be created, if it is 20 on the next day then F1..F20 have to be created. is it possible ?
Thanks Wassenaar, this is exactly what i wanted !!