Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need output like below straight table
IssuesId Previous_status Current_status IssuesIdcount date
11 closed open 1 01/01/18
22 closed open 1 02/01/18
33 closed open 1 03/01/18
Total-3
But I don't have Previous And current status fields.I have only one status field .using one status field drive the previous and current status field.
Like originalStatus field
closed
closed
open
If user select any two dates and compare those two dates one is min and one is max date calculate issues id when status changed close to open.
If user select 01/01/18(mindate) and 03/01/18(maxdate).if issuesid 11, 01/01/18 status is closed and same issuesId11 03/01/18 status changed to open Than calculate the issueId.
Hi!
Would it be possible to share sample data or qlikview file?
Rgds,
B
Hi Chaitanya ,
Please create fields like below:
Table1:
Load
IssuesId,
'closed' as Previous_status,
date
From Table SSS Where wildmatch(originalStatus,'closed');
Concatenate(Table1)
Load
IssuesId,
'Open' as Current_status,
date
From Table SSS Where wildmatch(originalStatus,'Open');
let me know if any further clarification.
Thanks,
Arvind Patil
Hi Arvind thanks for your reply.
I will try the above script.
But my requirement is user select any two dates in filters and compare the those two dates count the issuesids based on previous status is closed and changed to open than count the issuesId.
Example:
I have one month data and fields are IssuesId and IssuesStatus and date.
and I am creating straight table add the IssuesId previousstatus currentstatus countof Issuesid
if user select two dates in filters like 10/jan/18 and 12/jan/18 .and compare 10 and 12 dates what are the issuesids status is closed in date 10 and changed to status open in 12 than count the issuesId.