7 Replies Latest reply: Apr 13, 2017 12:05 PM by Andy Weir RSS

    Limiting Dimension Data by String Length

    David Murray

      Hi all,

       

      Just started using Qlik today, and I'm trying to display some of my data on a line chart, where the Date is on the X-Axis and Project Budget is on the Y-Axis. 

       

      The data set contains a list of project numbers and associated balances. A project ID is represented by a string of numbers that looks like XXXXX.YY.ZZZ, where each level has its own balance.  The data set is updated via concatenation each day.

       

      See below:

       

      DateProject IdBalance Available
      4/10/1712345100
      4/10/1712345.01100
      4/10/1712345.01.10170
      4/10/1712345.01.10230
      4/10/1754321200
      4/10/1754321.01200
      4/10/1754321.01.10150
      4/10/1754321.01.102150
      4/11/171234580
      4/11/1712345.0180
      4/11/1712345.01.10160
      4/11/1712345.01.10220
      4/11/1754321190
      4/11/1754321.01190
      4/11/1754321.01.10150
      4/11/1754321.01.102140

       

      My data set has roughly 100 unique Project Id numbers per day.  I would only like to graph the parent Project Id number, such that I would see the balances for 12345 and 54321 on the line chart by day.

       

      My Line Chart Dimensions are [Date] and [Project Id], and my Measure is [Balance Available].

       

      I'm looking to implement something that mimics either a "Select * From [Project Id] Where [Project Id].length = 5" or "Select * From [Project Id] Where ![Project Id].Contains ".""

       

      How do I limit the Line Chart [Project ID] Dimension to show only parent [Project Id]s? 

       

      Thank you,

      David