ROW_NUMBER() OVER(PARTITION BY PostalCode ORDER BY SalesYTD DESC) AS 'Row Number'
this is not possible in the edit screen right? i could solve this by first building a view in sql and then load the data from that view .. is this really not possible in Qlikview?
ROW_NUMBER() OVER(PARTITION BY PostalCode ORDER BY SalesYTD DESC) AS 'Row Number'
this solution works fine for a quite similar problem I have., so thanks a lot.
But I got one question. The load takes quite long (approx 60 minutes) as I'm loading about 21 Million records. Is there a way to do the same a bit faster? 🙂
9 years later, I'd love to make use of this. But since I'm using Qlik Sense, I don't think I can open that file type. Is there any way you could just post the script text?
