0 Replies Latest reply: May 15, 2017 3:12 PM by Gabriela Baldivia do Lago RSS

    Counter on QlikSense

    Gabriela Baldivia do Lago

      Hello everyone,

       

      I created an AutoNumber() on QlikView and it works ok. But on QlikSense it isn't working as well.

       

      The Calendar is by week. So every line is a different week.

      Every Vitrine has 4 week and the 13th Vitrine has 5 weeks.
      I'm breaking the calendar into Vitrines to number every week in the Vitrine.

       

      On QlikView the result is:

       

      It is correct.

       

      On QlikSense the result to the same code is:

      On QlikSense continues counting the line even though I store and drop the table Calendario and read again.

       

       

      The code:

       

      FOR vAno = 2012 to $(vMaxAno) // This variable is to set the max year that I have order

          FOR  vVitrine = 1 to 13

            

              Calendario:

              LOAD Ano,

                   Vitrine,

                   SemanaDtInicio,

                   SemanaDtFim,

                   Semana            as CalendarioSemana

              FROM [lib://App Data (global_ueg023)/dados\Ext\Calendario.qvd]

              (qvd);

            

       

                //In this part is selected just the 4 or 5 lines of the current Vitrine

              CalendarioVitrine1:

              LOAD Ano                                as Ano,

                   Vitrine                                as Vitrine,

                  CalendarioSemana                    as Semana,

                  right(CalendarioSemana, 2)            as [Semana do Ano],

                  Date(SemanaDtInicio, 'DD/MM/YYYY')     as [Inicio Semana],//AS [Pedido (Data de Início da Semana)],

                   Date(SemanaDtFim, 'DD/MM/YYYY')     AS [Fim da Semana] //[Pedido (Data de Fim da Semana)]

              Resident Calendario

              Where Ano = $(vAno) and

                  Vitrine = $(vVitrine)

              order by CalendarioSemana;

            

              drop table Calendario;

            

              Store CalendarioVitrine1 into [lib://$(DataFolder)/Ext/Calendario/Calendario_$(vAno)_$(vVitrine).qvd](qvd);

            

              drop table CalendarioVitrine1;

            

              CalendarioVitrine:

              Load *,

                   AutoNumber(Semana)    as SemanaMes

              FROM [lib://$(DataFolder)/Ext/Calendario/Calendario_$(vAno)_$(vVitrine).qvd]

              (qvd);

            

              Store CalendarioVitrine into [lib://$(DataFolder)/Ext/Calendario/Calendario_$(vAno)_$(vVitrine).qvd](qvd);

            

              drop table CalendarioVitrine;

            

          Next;

      Next;

       

      Someone know why it's happening?