Discussion board where members can get started with QlikView.
I had a gud support from u so far.Thanks for that.
I ve an excel source file. the columns are like M.13-17 Where M stands for Male and 13-17 for the age group.
Wat I need is, I want to seperate the columns into AgeGroup and Gender.
I tried with FieldName method.Its working for the first column only. There are 20 columns. I want to do this for all in the source file.
Help me to solve this problem.
Thanks in advance.
Go to Solution.
Please find the attached File.
Hope this helps u.
Thank u for that solution. it works.