6 Replies Latest reply: Sep 10, 2013 6:54 AM by Fabrizio Crespi RSS

    Question about table visualization

      Hi to all, I'm facing a problem with qlikview, I have a table object that display several rows. These rows contain 3 columns

       

      ID, Description and DateID

       

      ID is a numeric identifier

      Descritpiton is a text and DateId is a datetime created with a script found in a forum

       

      UNQUALIFY DateID;

       

       

       

       

      Date_src:

      LOAD

      $(StartDate) + ROWNO() -1 AS DateId

      AUTOGENERATE $(NumOfDays);

       

       

      Calendar:

      LOAD    

               DateId                                                                                       AS DateId      // just in case

              ,DATE(DateId)                                                                                                // in format defined in your SET DateFormat=, or in your system format

              ,DAY(DateId)                                                                                  AS Day

              ,WEEK(DateId)                                                                                 AS Week_S

              ,YEAR(DateId) & NUM(MONTH(DateId), '00') & NUM(DAY(DateId),'00')                              AS DateID

              ,MONTH(DateId)                                                                                AS Month_S    // simple month name; it is dual - numeric and text

              ,DUAL(MONTH(DateId) & '-' & YEAR(DateId), YEAR(DateId) & NUM(MONTH(DateId), '00'))            AS MonthYear   // Month-Year format, dual

              ,YEAR(DateId)                                                                                 AS Year_S

              ,WEEKDAY(DateId)                                                                              AS Weekday

              ,'Q' & CEIL(MONTH(DateId)/3)                                                                  AS Quarter     // in format Q1, Q2, Q3, Q4

              ,DUAL('Q' & CEIL(MONTH(DateId)/3) & '-' & YEAR(DateId), YEAR(DateId) & CEIL(MONTH(DateId)/3)) AS QtrYear     // Qn-Year, dual

      RESIDENT Date_src;

       

       

      DROP TABLE Date_src;

       

       

      LET NumOfDays = null();

       

      QlikView performs a LEFT OUTER JOIN so in my table object I have all rows in the database but I have several rows with only DateID value and a '-' as ID and Description.

       

      Is it possible to configure the table object to skip these rows containing only '-'

       

      Thank you in advance for your help.

      Best regards

      Fabrizio