Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (2)
1 Reply
Not applicable

Re: Quartiling data

anyone have any ideas on this one?

Gysbert Wassenaar

Community Browser