Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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 Status

Hi I have this table:

TRS_NOSEQUENCEDATEAMOUNTSTATUSAccountNo
101100111/14/20201000POSITIVE1001
102100121/17/2020400NEGATIVE1001
103100131/22/2020-1600POSITIVE1001
108100141/29/2020-6600NEGATIVE1001
109100151/29/20204000POSITIVE1001
110100162/15/2020-10NEGATIVE1001

 

If we have 2 change status is same date we should take max(sequence)

From 1/14/2020 to 1/16/2020 : POSITIVE   -->  3 days

From 1/17/2020 to 1/21/2020 : NEGATIVE --> 5 days

From 1/22/2020 to 2/15/2020 : POSITIVE   -->  25 days

And i want to display a chart ( line, bar  ....) any type of chart, like this one:

image0.jpeg

 

 

 

 

0 Replies