Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ch_riadh
Partner
Partner

Count Days Between First Time Status Change

Hi guys, 

This is my data

CustomerAccountDateBalanceStatus
1100101/04/2020-100Exceed
1100102/04/2020-150Exceed
1100103/04/2020200Normal
1100120/04/2020-120Exceed
1100110/05/2020-110Exceed
1100105/06/202020Normal
1100130/07/2020-60Exceed
1100201/04/2020180Normal
1100210/04/2020-90Exceed
1100230/04/2020220Normal
1100210/05/2020230Normal
1100212/05/2020-140Exceed
1100208/08/2020110Normal
2100310/04/2020290Normal
2100315/04/2020-300Exceed
2100330/04/2020350Normal
2100315/05/2020320Normal
2100312/07/2020-450Exceed
2100302/08/2020-600Exceed

 

I want to Display for each Account:

1 - The Last Time the status change from normal to Exceed.

2 - Today Status ( Last Status ).

3 - How many time the Status change from Normal to Exceed.

4 - Total Exceed days.

This is the output:

CustomerAccountLast Time Start ExceedToday StatusTimes went ExceedTotal Exceed Days
1100130/07/2020Exceed348
1100212/05/2020Normal2108
2100312/07/2020Exceed215

 

And

CustomerAccountDateBalanceStatusDays To Back to normal
1100101/04/2020-100Exceed 
1100102/04/2020-150Exceed 
1100103/04/2020200Normal2
1100120/04/2020-120Exceed 
1100110/05/2020-110Exceed 
1100105/06/202020Normal46
1100130/07/2020-60Exceed 
1100201/04/2020180Normal 
1100210/04/2020-90Exceed 
1100230/04/2020220Normal20
1100210/05/2020230Normal 
1100212/05/2020-140Exceed 
1100208/08/2020110Normal88
2100310/04/2020290Normal 
2100315/04/2020-300Exceed 
2100330/04/2020350Normal15
2100315/05/2020320Normal 
2100312/07/2020-450Exceed 
2100302/08/2020-600Exceed 

 

Please find attached excel for more clarification

Thank you in advance

0 Replies