topic Re: List Box with set analysis and AGGR in QlikView

List Box with set analysis and AGGR

laureadiaz — Sat, 16 Nov 2024 02:47:24 GMT

Hello,

I am trying to make a list box that finds every item/ID, that has been flagged with a Y for 1 field on a quote, but I want to find them for all entries not just the dates selected.

I think this is close but not quite there (getting no entries in the list box):

AGGR(IF(ONLY({$<year={"$(>='2019')"}, date_entry= , month= , week= , Period= , WPeriod= , PeriodID= >}
SD$ROIYN)='Y',
,Short_ID, null())
,quote_number, ordered_part_number, Short_ID)

This works but only for selected time frame:

IF(AGGR(SD$ROIYN, quote_number, ordered_part_number, Short_ID)='Y',
Short_ID, null())

Any ideas?

Re: List Box with set analysis and AGGR

Anil_Babu_Samineni — Thu, 08 Aug 2019 16:09:15 GMT

I don't know below one issue. But syntax should be

AGGR(IF(ONLY({$<year={">=2019"}, date_entry= , month= , week= , Period= , WPeriod= ,PeriodID= >}
SD$ROIYN)='Y', ,Short_ID, null()),quote_number, ordered_part_number, Short_ID)

Re: List Box with set analysis and AGGR

laureadiaz — Thu, 08 Aug 2019 16:20:01 GMT

Thanks,

I thought I was close!