Need 5 week rolling in my Qlikview Bar chart from max of week and Status must be closed

[sharu055]

Hello All, i hope your doing good. Could you please help .

I have 4 Column, Amount, Date, Week, Status . In which i need Sum of Amount in bar chart where rolling 5 week from Max of week and only status 'Closed' should show in the chart. should not alter for the status is open.

Amount               Date             Week          Status

12000                    Apr 07         18                Closed

26000                    Apr 07            18                Closed

16000                    Apr 014           19               Closed

6000                     Apr 014             19               Open

26000                    Apr 21               20               Open

6000                     Apr 28                21              Closed

46000                    May 4               22               Closed

12000                    May 4              22               Open

36000                    May 11            23              Closed

16000                    May 11            23              Open

6000                       May 18           24             Closed

21000                     May 18          24             Open

6000                       May 25           25             Closed

46000                    May 25            25             Open

[sharu055]

@MayilVahanan @sidhiq91  Thank you so much for the help

[sharu055]

@MayilVahanan @sidhiq91 @Anku  could you please for below question,

I have 3 columns in straight table. Team, Date, Result. Need the Sorting that Result column as primary sort that only only Won, Lost should appear as first and Tie, No  Result should come second and Date column should be as secondary sort  where  old dates should comes at first as ascending.  below are my input n needed output. please help

Input:

Team	Date	Result
IND	5/25/2022	Lost
CHI	5/15/2022	Tie
UK	4/22/2022	Lost
IND	4/31/2022	Won
UK	5/3/2022	No Result
USA	4/30/2022	Tie
CHI	5/31/2022	Won
USA	6/1/2022	No Result
UK	6/30/2022	Lost

After Sort Output need as below :

Team	Date	Result
UK	4/22/2022	Lost
IND	4/31/2022	Won
IND	5/25/2022	Lost
CHI	5/31/2022	Won
UK	6/30/2022	Lost
USA	4/30/2022	Tie
UK	5/3/2022	No Result
CHI	5/15/2022	Tie
USA	6/1/2022	No Result

Please help.