Discussion Board for collaboration related to QlikView App Development.
Can someone help me out on this challenge?
The left table in the attached qv shows the sourcedata (qvd attached).
The right pivot in the attached qv shows how it has to be converted.
What I need is a script which creates a qvd with what you see in the right table. (The script should do the job.)
So the data of the 'Station' field should become the fieldnames.
I have both attached the qvd and the qvw.
Any help appreciated!
Go to Solution.
LOAD Distinct TimeStampNew
For i = 1 to FieldValueCount('Station')
LET vStation = FieldValue('Station', $(i));
Left Join (NewTable)
LOAD Distinct TimeStampNew,
Measure as $(vStation)
Where Station = '$(vStation)';
DROP Table Measures;
STORE NewTable into Test2.qvd (qvd);
View solution in original post
works like charm man!!!
3rd time you made my day
Greetz from The Netherlands
You are keeping a count .
Hi Can you let me know how to achieve the following task
I have been trying some code examples and it's gives me duplicate row in the results