10 Replies Latest reply: Mar 21, 2017 11:19 AM by Ankit Gupta RSS

    Need Help in Converting Horizontal data as filter

    Ankit Gupta

      Hi All,

       

      I am dealing with a situation in Qlik Sense dashboard , where my Monthly Expenses data spans Horizontally in the excel (Excel file attached for reference) . Now I need to place a filters for Months, Qtr and Year and I am not sure how to do that .

       

      When I am loading data each column is coming separately in Qlik which will not solve the purpose to create filter.

       

      Can someone please help in this regard.

       

       

      Thx
      Ankit

        • Re: Need Help in Converting Horizontal data as filter
          mayuresh dabhekar

          hi ankit,

           

             please go to transformation step while loading excel into the qlikview.

          when u click enable transformation step button one window will open just click on next then in next window u will find option crosstable. click on that, then crosstable window will open there will u find three attributes. qualifier field,attribute field and date field. in qualifier field insert 1, then in attribute field insert month which will be like field name for months, and last will be field name for data. then click ok and then finish.

           

          and load data. this will solve ur problem.

           

          Thanks & regards,

          Mayuresh

          • Re: Need Help in Converting Horizontal data as filter
            mayuresh dabhekar

            hi aniket,

             

            one more take resident of this table by that u will do any operation u that u want to do on that table.

             

            following is the script which will appear

            where F1 is my projevt field and Jan is my month field and data is my data field:

             

            table1:

            CrossTable(Jan, Data)

            LOAD F1,

                 Jan,

                 Feb,

                 Mar,

                 Apr,

                 May,

                 Jun,

                 Jul,

                 Aug,

                 Sep,

                 Oct,

                 Nov,

                 Dec

            FROM

            D:\Calendar_Filter.xlsx

            (ooxml, embedded labels, table is Sheet1);

             

             

            table :

            load

            Jan

            ,Data,

            F1,

            1 as flag

            resident table1;

            drop table table1;

             

             

            thanks and regards,

            Mayuresh