topic Re: Permanently Filter Data Based on 2 Parameters in App Development

Permanently Filter Data Based on 2 Parameters

mskusace — Tue, 21 Dec 2021 21:48:24 GMT

I posted a similar topic regarding filtering data based on a single parameter, but I am unsure of how to do 2 parameters.

I need to filter a data set based on the year and also a flag variable.

YEAR = 2018

FLAG = Y

Currently, I have the expression below which filters it by YEAR = 2018, but I am not sure how to incorporate the FLAG = Y in there. Any assistance would be appreciated!

=aggr(only({<[YEAR]={2018}>}[ORDER]),[ORDER])

Re: Permanently Filter Data Based on 2 Parameters

Anil_Babu_Samineni — Fri, 02 Aug 2019 16:13:16 GMT

May be

=aggr(only({<[YEAR]={2018}, Flag={'Y'}>}[ORDER]),[ORDER])

Re: Permanently Filter Data Based on 2 Parameters

mskusace — Fri, 02 Aug 2019 16:15:00 GMT

I had tried that, but it did not work. I just tried again, still no luck.

Re: Permanently Filter Data Based on 2 Parameters

Anil_Babu_Samineni — Fri, 02 Aug 2019 16:19:33 GMT

Do you need, Only these filters need to effect for Order? Or you want to show only 2018 where Flag Y should not include. How you want to incorporate here?

Re: Permanently Filter Data Based on 2 Parameters

mskusace — Fri, 02 Aug 2019 16:22:07 GMT

I ONLY want the ENTIRE row to show if YEAR = 2018 AND FLAG = Y.

If YEAR <> 2018 AND FLAY <> Y, do NOT show the entire row.

I hope that clarifies.

Re: Permanently Filter Data Based on 2 Parameters

Anil_Babu_Samineni — Fri, 02 Aug 2019 16:25:48 GMT

I don't no where you are trying this? but you can simplify like below as condition and use Suppress when value is null or tick mark to the Include null values?

If(YEAR=2018 and Flag='Y', ORDER)

Re: Permanently Filter Data Based on 2 Parameters

mskusace — Fri, 02 Aug 2019 16:29:16 GMT

I was over complicating things too much!

Thank you very much! Your solution got me exactly what I was looking for.