4 Replies Latest reply: Sep 26, 2018 11:36 AM by Marina Dor RSS

    Filter on rows in straight table - Qlik Sense

    Ashish Palkar

      Hi There

       

      I have created Qlik Sense App. I am using straight table and some filters to see data. In my straight table i have dimensions , measures and date field called Maturity Date. 

       

      I want to create filed name called  "Days to Maturity" (integer number 1,2 ... to 30 ).

       

      When user selects any value in "Days to Maturity" (integer number 1,2 ... to 30 ). the data in straight table should change.


      i.e data in straight table should show between maturity date + "Days to Maturity"


      e.g If Maturity Date is 8/14/2018

             Days to Maturity = 5  

       

         Straight table should show data of dates 8/14/2018,8/15/2018 , 8/16/2018 ,8/15/2018 ,8/16/2018.


      any suggestions how to achieve this?


      thanks in advance. 

        • Re: Filter on rows in straight table - Qlik Sense
          Tomasz Truszkowski

          Is it possible to create flag in the script?

          Tomasz

            • Re: Filter on rows in straight table - Qlik Sense
              Ashish Palkar

              This is my script

               

              Data:

              LOAD

                  "ACCOUNT ID",

                  "ACCOUNT NAME",  // Report Filter

                  "BUSINESS UNIT",    // Report Filter

                  "MATURITY DATE",

                  "SECURITY ID",

                  "INSTRUMENT ID",

                  "SECUIRTY NAME",

                  InstrumentTypeTier2,

                  "Rate",

                  Quantity,

                  "MARKET VALUE",

                  COST,

                  "ACCRUED INTEREST",

                  PERCENT_of_PORTFOLIO,

                  BusinessDate,      // Report Filter

                  ExpiryDate   

              FROM [lib://$(QVDPath)/Maturity_QVD.qvd]

              (qvd);

               

               

              In report I am using following filters  ->>>>

                  "ACCOUNT NAME",  // Report Filter

                  "BUSINESS UNIT",    // Report Filter

                  BusinessDate,      // Report Filter

                  Days To Maturity // Integer Value

               

              Straight table is showing following fields, where maturity date should changes as per Days to maturity and Business Date Selection ->>>>

               

                  "ACCOUNT ID",

                  "MATURITY DATE",

                  "SECURITY ID",

                  "INSTRUMENT ID",

                  "SECUIRTY NAME",

                  InstrumentTypeTier2,

                  "Rate",

                  Quantity,

                  "MARKET VALUE",

                  COST,

                  "ACCRUED INTEREST",

                  PERCENT_of_PORTFOLIO,

            • Re: Filter on rows in straight table - Qlik Sense
              Marina Dor

              Hi,

               

              I think the approach is not the best, but not sure I understand what you want to do.


              Why don't you just :

              - Create a field [End Date], which is [Maturity Date] + [Days to Maturity]


              and then, in you straight table, add columns : [Maturity Date], [Days to Maturity] and [End Date], and allow users to filter on theses dates.

               

              Hope it helps anyway,

              Good luck,

              Marina