Field created with Script not Showing in Visualizations

[oric1884]

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,

Ciro

[its_anandrjs]

Can you share your sample file.

[oric1884]

Hi, Anand!

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

[swuehl]

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?

[oric1884]

Hi Stefan!

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

[swuehl]

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?

[oric1884]

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)

[swuehl]

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

[oric1884]

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] ;

[oric1884 · Accepted solution]

I think it's a release bug. I uptaded to September 2017 and fixed it.

Thank for yours help!