topic Re: Set Analysis Dynamically From Selected Array (via Filter) in App Development

Set Analysis Dynamically From Selected Array (via Filter)

brooksc57 — Tue, 04 Apr 2023 19:57:00 GMT

I'd have a Field YearQtr with Quarters in it from 2019Q1 and on.

If I select 4 Quarters in a field named YearQtr as follows 2021Q2, 2021Q3, 2022Q2, 2022Q3
I'd like to Dynamically perform Set Analysis on the Array of these selections.

So instead of defining the Quarters via Set Analysis like this Sum({$<YearQtr={'2021Q2'}>}NetSales)

I'd like it to Dynamically program the SetAnalysis like this

Sum({$<YearQtr={ Array Filter Position 1 }>}NetSales)

Sum({$<YearQtr={ Array Filter Position 2 }>}NetSales)

Sum({$<YearQtr={ Array Filter Position 3 }>}NetSales)

Sum({$<YearQtr={ Array Filter Position 4 }>}NetSales)

I feel like this could be possible but haven't stumbled on either a way or another post where I can find the right keywords to find it.

Thanks!

Re: Set Analysis Dynamically From Selected Array (via Filter)

Kushal_Chawda — Tue, 04 Apr 2023 21:01:34 GMT

@brooksc57 where would you use these individual set expression? could you elaborate more on your requirement?

Re: Set Analysis Dynamically From Selected Array (via Filter)

Sabrina_V — Wed, 05 Apr 2023 09:02:05 GMT

Hello,

Will you have one formula for each value of quater ?

I'm thinking of using a variable which will contained the values selected on the field Quater. In order to choose the first one, the second one ... you may use the function subfield.

Re: Set Analysis Dynamically From Selected Array (via Filter)

vinieme12 — Wed, 05 Apr 2023 10:19:42 GMT

refer this article

https://community.qlik.com/t5/Member-Articles/Period-Presets-Compare-Periods-on-the-fly/ta-p/1486371

Re: Set Analysis Dynamically From Selected Array (via Filter)

brooksc57 — Thu, 06 Apr 2023 00:12:58 GMT

Hi VP, that is a cool qvw. I am building a straight table so that it can sort easy, but that is a really nice 'app' for sure.

Re: Set Analysis Dynamically From Selected Array (via Filter)

brooksc57 — Thu, 06 Apr 2023 13:36:21 GMT

That is similar to what I was thinking. Both taking a night off from looking at it and also reading your thread has me there or very close at least.

The 1st Period would be something like this in a variable.

I imagine I could wrap that is some SetAnalysis as well but this will do.

=if(GetSelectedCount(YearMonth,False(),'Period1')>0,
Subfield(Concat({Period1}Distinct YearMonth,';'),';',1),
if(GetSelectedCount(YearQtr,False(),'Period1')>0,
Subfield(Concat({Period1}Distinct YearQtr,';'),';',1),
Subfield(Concat({Period1}Distinct Year,';'),';',1)
))