Set Expression Showing when a Member moves Bucket from a time frame

[Noor51]

Hello Everyone, 

I'm trying to write a set expression to show when Member moves bucket between Q1-2024 and Q2-2024 in a table. 

This is for Qlik sense on perm version May 2023. 

Any help would be appreciated. 

This is what I have so far 

If(
FirstSortedValue(
{<QuarterYear={'Q1-2024'}, [Class of Trade]={'ACUTE'}>} Bucket,
[Member]
) <>
FirstSortedValue(
{<QuarterYear={'Q2-2024'}, [Class of Trade]={'ACUTE '}>} Bucket,
[Member]
) and
Not IsNull(FirstSortedValue(
{<QuarterYear={'Q1-2024'}, [Class of Trade]={'ACUTE '}>} Bucket,
[Member]
)),
'Moved',
'No Change'
)

[Kushal_Chawda]

@Noor51  It is always better to do this kind of calculation in the script.

Data:
Load * Inline [
Member	QuarterYear	Bucket 
001 IL	Q1-2024	> 64 %
002 AZ	Q2-2024	65 - 74%
003 WI	Q3-2024	75 - 84 %
004 NY	Q1-2024	85  - 90 %
001 IL	Q2-2024	85  - 90 %
002 AZ	Q1-2024	75 - 84 %
003 WI	Q2-2024	65 - 74%
004 NY	Q2-2024	> 64 %
005 OH	Q3-2024	75 - 84 %
006 WY	Q2-2024	65 - 74%
005 OH	Q4-2024	65 - 74%
006 WY	Q3-2024	> 64 % ] (delimiter is '\t');

final:
Load *,
     if(Member=Previous(Member) and WildMatch(QuarterYear,'Q2*') and WildMatch(previous(QuarterYear),'Q1*')
      and Bucket<>Previous(Bucket),'Change','No Change') as Flag
Resident Data
Order by Member,QuarterYear;

Drop Table Data;