topic Grouping data in a listbox - aggr function? (long explanation...) in QlikView

Grouping data in a listbox - aggr function? (long explanation...)

Fri, 28 Aug 2015 09:15:49 GMT

Hi experts,

i don't know how to face the following problem:

- suppose i have a list of stock forward quotation, about on a daily basis; let's say 200 quotation per year (ReferenceDate in the sample)

- then i want to compare two or more forward quotations from different ReferenceDate

it's easy, i did it in the sample.....just thick in the listbox two or more items

but if i have hundred of Reference dates, users should scroll through a lot of items;

i think that the ideal solution is to add another listbox with a subset of Reference Date (the first quotation of the month/quarter); in this case user should select the first reference from the second listbox and the add any number of other ReferenceDate in the first listbox.

the second list box should look :

02/01/2015

01/04/2015

quarter1 2015

quarter2 2015

I added a second listbox (quarter) but (obviously) when i select 01/01/2015 i select a couple of values in the first listbox rather then 02/01/2015 only.

I added another listbox (quarter 2) with the expression:

=aggr(min(ReferenceDate), QuarterStart(ReferenceDate))

but doesn't work .... (for sure i'm not a qlik expert)

Anyone can help me to solve this problem

Thanks in advance

Stefano

Re: Grouping data in a listbox - aggr function? (long explanation...)

hic — Fri, 28 Aug 2015 09:42:01 GMT

If you create a field "Quarter" in the script, will this not solve your problem? E.g.

load *,

QuarterName(ReferenceDate) as Quarter

inline [...]

Re: Grouping data in a listbox - aggr function? (long explanation...)

Fri, 28 Aug 2015 09:57:25 GMT

Hi Henric,

thanks for you reply.

probably my request was confused .....

If i add the field quarter (as per you suggestion), as i select a quarter, ALL forward quotations are included in the chart (about 60);

I'd like to include in the graph only the first quotation for the selected quarter (02/01/2015 if i thick first quarter)

Stefano