Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sharu055
Contributor III
Contributor III
‎2022-07-28 10:53 AM

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

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

279 Views
0 Likes
11 Replies
sharu055
Contributor III
Contributor III
‎2022-08-03 06:51 AM
Author

@MayilVahanan @sidhiq91  Thank you so much for the help

35 Views
0 Likes
sharu055
Contributor III
Contributor III
‎2022-08-08 02:18 PM
Author

@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.

30 Views
0 Likes