Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
laureadiaz
Contributor III
Contributor III

List Box with set analysis and AGGR

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?

Labels (2)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
laureadiaz
Contributor III
Contributor III
Author

Thanks,

 

    I thought I was close!