Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am looking for some help in the script in Qlikview which will help me produce a table ush as this. I need to be able to produce such a table in the script, rather than in the body of the QVW, as I will be referencing the table in other parts of the script
I want to achieve a table which will look like this:
Country | Locations | location pcode | latitude | longitude | pcode | latitude2 | longitude2 | Referrals |
uk | Andover | SP117SA | 51.194142 | -1.507834 | SP117SA | 51.194142 | -1.507834 | 4 |
uk | Andover | SP117SA | 51.194142 | -1.507834 | SP104RP | 51.221722 | -1.502514 | 3 |
uk | Andover | SP117SA | 51.194142 | -1.507834 | SP101JY | 51.212444 | -1.468069 | 2 |
uk | Andover | SP117SA | 51.194142 | -1.507834 | SP102HF | 51.198956 | -1.483524 | 10 |
I have attached a QVW which shows how the data is currently being stored. Can anyone help me or get me started
Your help is very much appreciated
Thanks
Helen
Hi,
I can´t understand the problem. As I see in the document, you already have a table (sheet2) loaded in the script, and it looks like the way you want it...
As I say, I think I didn´t understand the problem...