PLANILHA EXCELLE

Anonymous — Sun, 07 Aug 2016 11:25:45 GMT

Good Morning,

I have a spreadsheet in excell containing some columns in horinzontal and need her fiquel upright columns months and values are the same in green and blue. someone would have an idea of how to do?

I am sending attached.

Re: PLANILHA EXCELLE

marcus_sommer — Sun, 07 Aug 2016 12:25:45 GMT

You could transform your horizontal columns per The Crosstable Load into a normal table-structure and a match between the string monthnames to the numeric monthnumbers could be done per Mapping … and not the geographical kind.

- Marcus

Re: PLANILHA EXCELLE

veidlburkhard — Sun, 07 Aug 2016 12:45:04 GMT

Hi Oliveira,

your excel file is kind of a cross table. With the below script you can load this file easily:

CrossTable(Mes, Value, 16)

LOAD [Código do Sistema],

[Tipo de Movimento],

[Ano do Orçamento],

[Mês do Orçamento],

[Código da Empresa],

[Código da Unidade],

[Código do Centro],

[Código Conta Orçamentária],

[Quantidade do Movimento],

[Valor do Movimento],

[Valor Fixo],

[Nome do Arquivo],

[Ano do Plano],

[Código Conta Contábil],

[Código de Entrada],

Data,

Janeiro,

Fevereiro,

Março,

Abril,

Maio,

Junho,

Julho,

Agosto,

Setembro,

Outubro,

Novembro,

Dezembro

FROM

Base_Excell.xlsx

(ooxml, embedded labels, table is Plan1, filters(

ColXtr(11, RowCnd(Every), 0),

ColXtr(12, RowCnd(Every), 0),

ColXtr(13, RowCnd(Every), 0),

ColXtr(14, RowCnd(Every), 0),

ColXtr(15, RowCnd(Every), 0),

ColXtr(16, RowCnd(Every), 0),

ColXtr(17, RowCnd(Every), 0),

ColXtr(18, RowCnd(Every), 0),

ColXtr(19, RowCnd(Every), 0),

ColXtr(20, RowCnd(Every), 0),

ColXtr(21, RowCnd(Every), 0),

ColXtr(22, RowCnd(Every), 0),

Remove(Col, Pos(Top, 22)),

Remove(Col, Pos(Top, 21)),

Remove(Col, Pos(Top, 20)),

Remove(Col, Pos(Top, 19)),

Remove(Col, Pos(Top, 18)),

Remove(Col, Pos(Top, 17)),

Remove(Col, Pos(Top, 16)),

Remove(Col, Pos(Top, 15)),

Remove(Col, Pos(Top, 14)),

Remove(Col, Pos(Top, 13)),

Remove(Col, Pos(Top, 12)),

Remove(Col, Pos(Top, 11))

));

Hope this helps.

Burkhard

Re: PLANILHA EXCELLE

Anonymous — Fri, 16 Sep 2016 21:52:35 GMT

thank you

topic Re: PLANILHA EXCELLE in QlikView

PLANILHA EXCELLE

Re: PLANILHA EXCELLE

Re: PLANILHA EXCELLE

Re: PLANILHA EXCELLE