3 Replies Latest reply: Jul 24, 2018 3:41 AM by chaitanya krishna RSS

    help me on below requiement?

    chaitanya krishna

      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.

        • Re: help me on below requiement?
          Benazir Khan

          Hi!

           

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

           

          Rgds,

          B

          • Re: help me on below requiement?
            Arvind Patil

            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



              • Re: help me on below requiement?
                chaitanya krishna

                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.