Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Quartiling data

I want to quartile a group of "Primary Tickers" against a "Conviction sector" and "Year".   and join the quartile data to the right of the  table (as below). Is this an Aggr function?

PRIMARY_TICKERMetricConviction Sector descriptionYearDataSector Quartile
000001.SZCROCI_INCL_LEASESOilCY 20040.153
000002.SZCROCI_INCL_LEASESOilCY 20040.262
000003.SZCROCI_INCL_LEASESOilCY 20040.271
000003.SZCROCI_INCL_LEASESOilCY 20040.014

Many thanks in advance

1 Reply
Not applicable

anyone have any ideas on this one?

Gysbert Wassenaar