9 Replies Latest reply: Sep 23, 2017 5:01 PM by Ciro ORIC RSS

    Field created with Script not Showing in Visualizations

    Ciro ORIC

      Hi there!

       

      I have a strange issue with my Qlik Sense app.

       

      I created a field using script editor (field mySequencialMonth) picture 1

       

      I can see this field at table editor (data manager) picture 2

       

      But I can't find it to insert in my visualization. picture 3

       

      Any clue?

       

      Many thanks for any kind of help.

       

      Regards,

       

      CiroField Issue.png

        • Re: Field created with Script not Showing in Visualizations
          Anand Chouhan

          Can you share your sample file.

            • Re: Field created with Script not Showing in Visualizations
              Ciro ORIC

              Hi, Anand!

               

              Thank you to reply. By the way, I'm using Qlik Sense release June 2017

                • Re: Field created with Script not Showing in Visualizations
                  Stefan Wühl

                  The field is already not showing up in data modell view.

                   

                  Seems like there could be an issue with using this field for automatic calendar generation.

                  Since you don't need a calendar on this field (you can use the calendar based on field DATAEMI , the base date used for your mySequentialMonth), could you remove the calendar on your field mySequentialMonth (I assume you set this property in data manager, I can't see the details because data manager needs access to your data sources) and reload?

                    • Re: Field created with Script not Showing in Visualizations
                      Ciro ORIC

                      Hi Stefan!

                       

                      Even if a create a field like: '1' as myNumber, the issue occurs.

                        • Re: Field created with Script not Showing in Visualizations
                          Stefan Wühl

                          Check if this field is part of the automatic script generated at the end of your load script.

                          Is there any special treatment for the new field?

                            • Re: Field created with Script not Showing in Visualizations
                              Ciro ORIC

                              I think there's no special treatment:

                               

                              Carga de arquivos iniciada

                              MARCA << Plan1 Linhas buscadas: 141 GRUPO << Plan1 Linhas buscadas: 3 COLECAO << Plan1 Linhas buscadas: 4 SEGMENTO << Plan1 Linhas buscadas: 135 PRODUTO << Plan1

                              Linhas buscadas: 22.070 VENDEDORES << Plan1 Linhas buscadas: 70

                              VEN_CAB << Plan1

                              Linhas buscadas: 5.357 VEN_COR << Plan1

                              Linhas buscadas: 22.838 MARCA_temp_5d34bf06-bfc8-6075-8a1d-81b957f4 << MARCA Linhas buscadas: 141 GRUPO_temp_67b23c02-7115-404a-76f5-2106e9f3 << GRUPO Linhas buscadas: 3 COLECAO_temp_bb153ba9-c88c-c544-bd99-e75b3902 << COLECAO Linhas buscadas: 4 SEGMENTO_temp_34e62334-70dd-aad3-db9d-f37bf583 << SEGMENTO Linhas buscadas: 135 PRODUTO_temp_142c227d-872a-ae4f-3e5e-72a6f964 << PRODUTO Linhas buscadas: 22.070 VENDEDORES_temp_e01c7b35-fa8a-a177-0c02-aa0d9e92 << VENDEDORES Linhas buscadas: 70 VEN_CAB_temp_91f4f926-bd0d-63dc-4c67-8c2f418a << VEN_CAB Linhas buscadas: 5.357 VEN_COR_temp_42bf009e-b74e-d424-97d1-1d08b896 << VEN_COR

                              Linhas buscadas: 22.838 Criando índice de pesquisa Criação do índice de pesquisa concluída com sucesso

                              Aplicativo salvo

                              Concluído com êxito

                              0 erro(s) forçado(s)

                              0 chave(s) sintética(s)

                                • Re: Field created with Script not Showing in Visualizations
                                  Stefan Wühl

                                  No, I was talking about the automatically generated script part when you open script / data editor.

                                    • Re: Field created with Script not Showing in Visualizations
                                      Ciro ORIC

                                      RENAME TABLE [VENDEDORES_temp_bdad3144-36f0-ffaf-3011-2e7dcb71] TO [VENDEDORES];

                                      RENAME TABLE [VEN_CAB_temp_b9f09f88-0291-ac5c-8d2b-be6abd95] TO [VEN_CAB];

                                      RENAME TABLE [VEN_COR_temp_18a63673-7ae8-4ec6-1556-5984baf6] TO [VEN_COR];

                                       

                                       

                                      [autoCalendar]:

                                        DECLARE FIELD DEFINITION Tagged ('$date')

                                      FIELDS

                                        Dual(Year($1), YearStart($1)) AS [Year] Tagged ('$axis', '$year'),

                                        Dual('Q'&Num(Ceil(Num(Month($1))/3)),Num(Ceil(NUM(Month($1))/3),00)) AS [Quarter] Tagged ('$quarter', '$cyclic'),

                                        Dual(Year($1)&'-Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [YearQuarter] Tagged ('$yearquarter', '$qualified'),

                                        Dual('Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [_YearQuarter] Tagged ('$yearquarter', '$hidden', '$simplified'),

                                        Month($1) AS [Month] Tagged ('$month', '$cyclic'),

                                        Dual(Year($1)&'-'&Month($1), monthstart($1)) AS [YearMonth] Tagged ('$axis', '$yearmonth', '$qualified'),

                                        Dual(Month($1), monthstart($1)) AS [_YearMonth] Tagged ('$axis', '$yearmonth', '$simplified', '$hidden'),

                                        Dual('W'&Num(Week($1),00), Num(Week($1),00)) AS [Week] Tagged ('$weeknumber', '$cyclic'),

                                        Date(Floor($1)) AS [Date] Tagged ('$axis', '$date', '$qualified'),

                                        Date(Floor($1), 'D') AS [_Date] Tagged ('$axis', '$date', '$hidden', '$simplified'),

                                        If (DayNumberOfYear($1) <= DayNumberOfYear(Today()), 1, 0) AS [InYTD] ,

                                        Year(Today())-Year($1) AS [YearsAgo] ,

                                        If (DayNumberOfQuarter($1) <= DayNumberOfQuarter(Today()),1,0) AS [InQTD] ,

                                        4*Year(Today())+Ceil(Month(Today())/3)-4*Year($1)-Ceil(Month($1)/3) AS [QuartersAgo] ,

                                        Ceil(Month(Today())/3)-Ceil(Month($1)/3) AS [QuarterRelNo] ,

                                        If(Day($1)<=Day(Today()),1,0) AS [InMTD] ,

                                        12*Year(Today())+Month(Today())-12*Year($1)-Month($1) AS [MonthsAgo] ,

                                        Month(Today())-Month($1) AS [MonthRelNo] ,

                                        If(WeekDay($1)<=WeekDay(Today()),1,0) AS [InWTD] ,

                                        (WeekStart(Today())-WeekStart($1))/7 AS [WeeksAgo] ,

                                        Week(Today())-Week($1) AS [WeekRelNo] ;

                                       

                                      DERIVE FIELDS FROM FIELDS [mySequencialMonth], [DATAEMI] USING [autoCalendar] ;