Discussion Board for collaboration on QlikView Scripting.
I have to write a script for this sort of data. how it would be possible?
As this is just a dummy data which i have on my excel sheet.
I have multiple sheets all containting the same number of fields but with different dates.
|For the month of JAN||Total|
I wrote up this simple script :
[Day:TUSEDAY 01/01/2013] as Day
(ooxml, embedded labels, header is 1 lines, table is [1 JAN], filters(
But Follow-Up fields contain two Sub-fields (Later,Not interested) and kindly help me with the date aswell.
Please help me in creating the correct script.
Solved! Go to Solution.
Many thanks Mark.
You solved my problem to some extent, but still i am unable to lookup the 'Later' and 'Not interested' field, as if we delete the first row after transposing then these two fields will get deleted aswell.
The Follow-up field consists of two different fields "Later and Not-Interested", its more likely hierarchical.
I want to compute these two fields separately.
Seeking guidance from you.
Many thanks again.