Discussion Board for collaboration on QlikView Scripting.
I have the following data (small snapshot) that I am unable to change at the source:
I want to pull in the data into a cross tab to like this:
Would also be great if I could remove the "CY " from the Year!
Go to Solution.
See attached qvw.
I promise no more after this one Gysbert! !
I also want to quartile the data you have created in the attached against another field in my model called "Conviction Sector description"
So essentially I want to quartile a group of "Primary Tickers" against a "Conviction sector" and "Year". and join the quartile data to the same table (as below). Is this an Aggr function?
I appreciate this is probably pushing it - but any help would be most grateful.