Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gkcchowdary
Contributor

help me on below requiement?

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.

3 Replies
benazirkhan
Contributor II

Re: help me on below requiement?

Hi!

Would it be possible to share sample data or qlikview file?

Rgds,

B

arvind_patil
Valued Contributor II

Re: help me on below requiement?

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



gkcchowdary
Contributor

Re: help me on below requiement?

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.

Community Browser