1 Reply Latest reply: Sep 28, 2016 9:59 AM by Noha Salem RSS

    Date table and connection

    Noha Salem

      Hi Everyone,

       

      Now I want to create a neutral Date table (in data load editor) to use its columns in creating Visualization filters then after that I want to link every chart in the visualization to the current selection on those filters.

       

      Breaking up the question:

      1. Neutral Date and time table Script for Qlik sense 

      2. A selection statement for showing only what is selected in visualization selection.

       

      Thanks In advance

        • Re: Date table and connection
          Noha Salem

          so for the first part of my question I created a neutral table using the following script if anyone would like to use it ;

           

          [MCMonth]:

          load Month(makedate(2000,rowNo(),01)) as "Month"

          autogenerate 12;

           

          [MCDay]:

          Load rowNo() as "Day"

          autogenerate 31;

           

          [MCYear]:

          Load year(now())+1 - RowNo() as "Year"

          autogenerate 5;


          this creates 3 tables one for year ,one for month and one for day.