Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mxell
Contributor III
Contributor III
‎2024-02-06 08:30 AM

Organizar organograma no modelo abaixo

Olá

seria possível montar o organograma nesse modelo?

 

Onde o RH, FINANCEIRO, TI e CONTÁBIL estão ligados diretamente ao PRESIDENTE, porém em níveis diferentes?

 

Fip7t0MSHoWPLg__En9_wHE_FYiah_MtTQ.png

 

Labels (1)
Labels
738 Views
11 Replies
marksouzacosta
Partner - Specialist
Partner - Specialist
‎2024-02-06 08:40 AM

Sim, é possível. Se você tiver os nomes e os campos das tabelas posso fazer um modelo aqui pra você com o código funcionando.

Read more at Data Voyagers - datavoyagers.net
533 Views
mxell
Contributor III
Contributor III
‎2024-02-06 08:45 AM
Author

Opa, segue campos e tabela

SQL SELECT "cdn_plano_lotac",
"cod_unid_lotac_pai",
"cod_unid_lotac_filho"
FROM [lib://QVDPath/qvd_organograma.qvd]
(qvd);

 

cod_unid_lotac_pai cod_unid_lotac_filho
  G200000000
  G100000000
E112320000 E112321000
E112321000 E112321200
E112321000 E112321100
E112321100 E112321108
E112321100 E112321107
E112321100 E112321106
E112321100 E112321105
E112321100 E112321104
E112321100 E112321103
E112321100 E112321102
E112321100 E112321101
E112321200 E112321208
E112321200 E112321207
E112321200 E112321206
E112321200 E112321205
E112321200 E112321204
E112321200 E112321203
E112321200 E112321202
E112321200 E112321201
E112414000 E112414100
E112414100 E112414101
F112133000 f112133100
f112133100 F112133101
F112210000 F112215000
F112210000 F112214000
F112210000 F112213000
F112210000 F112212000
F112210000 F112211000
F112211000 F112211100
F112211100 F112211101
F112212000 F112212100
F112212100 F112212103
F112212100 F112212102
F112212100 F112212101
F112213000 F112213100
F112213100 F112213105
F112213100 F112213104
F112213100 F112213103
F112213100 F112213102
F112213100 F112213101
F112214000 F112214100
F112214100 F112214101
F112215000 F112215100
F112215100 F112215104
F112215100 F112215103
F112215100 F112215102
F112215100 F112215101
F112413000 F112413100
F112413100 F112413101
G100000000 G110000000
G100000000 G100000002
G100000000 G100000001
G110000000 G113000000
G110000000 G112000000
G110000000 G111000000
G110000000 G110000001
G111000000 G111300000
G111000000 G111200000
G111000000 G111100000
G111100000 G111140000
G111100000 G111130000
G111100000 G111120000
G111100000 G111110000
G111110000 G111111000
G111111000 G111111100
G111111100 G111111101
G111120000 G111121000
G111121000 G111121100
G111121100 G111121101
G111130000 G111131000
G111131000 G111131100
G111131100 G111131101
G111140000 G111141000
G111141000 G111141100
G111141100 G111141101
G111200000 G111230000
G111200000 G111220000
G111200000 G111210000
G111210000 G111211000
G111211000 G111211100
G111211100 U111211104
G111211100 G111211101
G111211100 F111211103
G111211100 E111211102
G111220000 G111221000
G111221000 G111221200
G111221000 G111221100
G111221100 G111221101
G111221200 G111221201
G111230000 G111231000
G111231000 G111231300
G111231000 G111231200
G111231000 G111231100
G111231100 G111231101
G111231200 G111231302
G111231200 G111231201
G111231300 G111231301
G111300000 G111320000
G111300000 G111310000
G111310000 G111311000
G111311000 G111311100
G111311100 G111311101
G111320000 G111321000
G111321000 G111321400
G111321000 G111321300
G111321000 G111321200
G111321000 G111321100
G111321100 G111321101
G111321200 G111321201
G111321300 G111321301
G111321400 G111321401
G112000000 G112500000
G112000000 G112400000
G112000000 G112300000
G112000000 G112200000
G112000000 G112100000
G112100000 G112130000
G112100000 G112120000
G112100000 G112110000
G112110000 G112111000
G112111000 G112111100
G112111100 U112111103
G112111100 G112111101
G112111100 F112111102
G112111100 E112111104
G112120000 G112121000
G112121000 G112121200
G112121000 G112121100
G112121100 U112121104
G112121100 G112121102
G112121100 G112121101
G112121100 F112121103
G112121100 E112121105
G112121200 G112121202
G112121200 G112121201
G112130000 G112132000
G112130000 G112131000
G112130000 F112133000
G112131000 G112131100
G112131100 G112131101
G112132000 G112132100
G112132100 U112132103
G112132100 G112132101
G112132100 E112132102
G112200000 F112210000
G112300000 U112310000
G112300000 E112320000
G112400000 G112410000
G112410000 U112415000
G112410000 G112412000
G112410000 G112411000
G112410000 F112413000
G112410000 E112414000
G112411000 G112411100
G112411100 G112411101
G112412000 G112412100
G112412100 G112412101
G112500000 G112510000
G112510000 G112511000
G112511000 G112511100
G112511100 G112511101
G113000000 G113200000
G113000000 G113100000
G113100000 G113130000
G113100000 G113120000
G113100000 G113110000
G113110000 G113111000
G113111000 G113111200
G113111000 G113111100
G113111100 G113111101
G113111200 G113112201
G113120000 G113121000
G113121000 G113121100
G113121100 G113121101
G113130000 G113131000
G113131000 G113131100
G113131100 G113131102
G113131100 G113131101
G113200000 G113250000
G113200000 G113240000
G113200000 G113230000
G113200000 G113220000
G113200000 G113210000
G113210000 G113211000
G113211000 G113211400
G113211000 G113211300
G113211000 G113211200
G113211000 G113211100
G113211100 G113211101
G113211200 G113211202
G113211200 G113211201
G113211300 G113211301
G113211400 G113211402
G113211400 G113211401
G113220000 G113221000
G113221000 G113221200
G113221000 G113221100
G113221100 G113221101
G113221200 G113221201
G113230000 G113231000
G113231000 G113231200
G113231000 G113231100
G113231100 U113231103
G113231100 G113231101
G113231100 F113231104
G113231100 E113231102
G113231200 G113231201
G113240000 G113241000
G113241000 G113241300
G113241000 G113241200
G113241000 G113241100
G113241100 G113241101
G113241200 G113241201
G113241300 G113241301
G113250000 G113251000
G113251000 G113251200
G113251000 G113251100
G113251100 G113251101
G113251200 G113251201
U112310000 U112311000
U112311000 U112311300
U112311000 U112311200
U112311000 U112311100
U112311100 U112311106
U112311100 U112311105
U112311100 U112311104
U112311100 U112311103
U112311100 U112311102
U112311100 U112311101
U112311200 U112311205
U112311200 U112311204
U112311200 U112311203
U112311200 U112311202
U112311200 U112311201
U112311300 U112311302
U112311300 U112311301
U112415000 U112415100
U112415100 U112415101
396 Views
mxell
Contributor III
Contributor III
‎2024-02-06 08:48 AM
Author

Opa!

 

Segue tabela e os campos

 

cod_unid_lotac_pai cod_unid_lotac_filho
  G200000000
  G100000000
E112320000 E112321000
E112321000 E112321200
E112321000 E112321100
E112321100 E112321108
E112321100 E112321107
E112321100 E112321106
E112321100 E112321105
E112321100 E112321104
E112321100 E112321103
E112321100 E112321102
E112321100 E112321101
E112321200 E112321208
E112321200 E112321207
E112321200 E112321206
E112321200 E112321205
E112321200 E112321204
E112321200 E112321203
E112321200 E112321202
E112321200 E112321201
E112414000 E112414100
E112414100 E112414101
F112133000 f112133100
f112133100 F112133101
F112210000 F112215000
F112210000 F112214000
F112210000 F112213000
F112210000 F112212000
F112210000 F112211000
F112211000 F112211100
F112211100 F112211101
F112212000 F112212100
F112212100 F112212103
F112212100 F112212102
F112212100 F112212101
F112213000 F112213100
F112213100 F112213105
F112213100 F112213104
F112213100 F112213103
F112213100 F112213102
F112213100 F112213101
F112214000 F112214100
F112214100 F112214101
F112215000 F112215100
F112215100 F112215104
F112215100 F112215103
F112215100 F112215102
F112215100 F112215101
F112413000 F112413100
F112413100 F112413101
G100000000 G110000000
G100000000 G100000002
G100000000 G100000001
G110000000 G113000000
G110000000 G112000000
G110000000 G111000000
G110000000 G110000001
G111000000 G111300000
G111000000 G111200000
G111000000 G111100000
G111100000 G111140000
G111100000 G111130000
G111100000 G111120000
G111100000 G111110000
G111110000 G111111000
G111111000 G111111100
G111111100 G111111101
G111120000 G111121000
G111121000 G111121100
G111121100 G111121101
G111130000 G111131000
G111131000 G111131100
G111131100 G111131101
G111140000 G111141000
G111141000 G111141100
G111141100 G111141101
G111200000 G111230000
G111200000 G111220000
G111200000 G111210000
G111210000 G111211000
G111211000 G111211100
G111211100 U111211104
G111211100 G111211101
G111211100 F111211103
G111211100 E111211102
G111220000 G111221000
G111221000 G111221200
G111221000 G111221100
G111221100 G111221101
G111221200 G111221201
G111230000 G111231000
G111231000 G111231300
G111231000 G111231200
G111231000 G111231100
G111231100 G111231101
G111231200 G111231302
G111231200 G111231201
G111231300 G111231301
G111300000 G111320000
G111300000 G111310000
G111310000 G111311000
G111311000 G111311100
G111311100 G111311101
G111320000 G111321000
G111321000 G111321400
G111321000 G111321300
G111321000 G111321200
G111321000 G111321100
G111321100 G111321101
G111321200 G111321201
G111321300 G111321301
G111321400 G111321401
G112000000 G112500000
G112000000 G112400000
G112000000 G112300000
G112000000 G112200000
G112000000 G112100000
G112100000 G112130000
G112100000 G112120000
G112100000 G112110000
G112110000 G112111000
G112111000 G112111100
G112111100 U112111103
G112111100 G112111101
G112111100 F112111102
G112111100 E112111104
G112120000 G112121000
G112121000 G112121200
G112121000 G112121100
G112121100 U112121104
G112121100 G112121102
G112121100 G112121101
G112121100 F112121103
G112121100 E112121105
G112121200 G112121202
G112121200 G112121201
G112130000 G112132000
G112130000 G112131000
G112130000 F112133000
G112131000 G112131100
G112131100 G112131101
G112132000 G112132100
G112132100 U112132103
G112132100 G112132101
G112132100 E112132102
G112200000 F112210000
G112300000 U112310000
G112300000 E112320000
G112400000 G112410000
G112410000 U112415000
G112410000 G112412000
G112410000 G112411000
G112410000 F112413000
G112410000 E112414000
G112411000 G112411100
G112411100 G112411101
G112412000 G112412100
G112412100 G112412101
G112500000 G112510000
G112510000 G112511000
G112511000 G112511100
G112511100 G112511101
G113000000 G113200000
G113000000 G113100000
G113100000 G113130000
G113100000 G113120000
G113100000 G113110000
G113110000 G113111000
G113111000 G113111200
G113111000 G113111100
G113111100 G113111101
G113111200 G113112201
G113120000 G113121000
G113121000 G113121100
G113121100 G113121101
G113130000 G113131000
G113131000 G113131100
G113131100 G113131102
G113131100 G113131101
G113200000 G113250000
G113200000 G113240000
G113200000 G113230000
G113200000 G113220000
G113200000 G113210000
G113210000 G113211000
G113211000 G113211400
G113211000 G113211300
G113211000 G113211200
G113211000 G113211100
G113211100 G113211101
G113211200 G113211202
G113211200 G113211201
G113211300 G113211301
G113211400 G113211402
G113211400 G113211401
G113220000 G113221000
G113221000 G113221200
G113221000 G113221100
G113221100 G113221101
G113221200 G113221201
G113230000 G113231000
G113231000 G113231200
G113231000 G113231100
G113231100 U113231103
G113231100 G113231101
G113231100 F113231104
G113231100 E113231102
G113231200 G113231201
G113240000 G113241000
G113241000 G113241300
G113241000 G113241200
G113241000 G113241100
G113241100 G113241101
G113241200 G113241201
G113241300 G113241301
G113250000 G113251000
G113251000 G113251200
G113251000 G113251100
G113251100 G113251101
G113251200 G113251201
U112310000 U112311000
U112311000 U112311300
U112311000 U112311200
U112311000 U112311100
U112311100 U112311106
U112311100 U112311105
U112311100 U112311104
U112311100 U112311103
U112311100 U112311102
U112311100 U112311101
U112311200 U112311205
U112311200 U112311204
U112311200 U112311203
U112311200 U112311202
U112311200 U112311201
U112311300 U112311302
U112311300 U112311301
U112415000 U112415100
U112415100 U112415101
495 Views
marksouzacosta
Partner - Specialist
Partner - Specialist
‎2024-02-06 08:57 AM

Fala Mxell,

Não sei se me expressei bem.
Eu estava esperando algo parecido com isso:

Tabela: Presidente
Campos:
PresidenteID,
Nome,
Descricao,
etc..


Tabela: Financeiro
Campos:
FinanceiroID,
PresidenteID,
Nome,
Descricao,
etc..

Tabela: RH
Campos:
RH_ID,
PresidenteID,
Nome,
Descricao,
etc..

Pode ser imagem também de diagrama de banco de dados. Isso ajudaria bastante.

Read more at Data Voyagers - datavoyagers.net
474 Views
mxell
Contributor III
Contributor III
‎2024-02-06 10:39 AM
Author

Aah entendi, @marksouzacosta.

é que na verdade a nossa estrutrura é diferente. De tabela eu só tenho essa que te mandei, está dessa forma no banco de dados, onde jogo o filho e o pai no grafico de organograma e ele monta sozinho. 

Teria um transformador para separar os nós ou deveria ser montado de outra forma? 

 

Não sei se contribui com a informação, mas retiro do ERP Totvs Datasul, tabela estrut_plano_lotac

 

437 Views
mxell
Contributor III
Contributor III
‎2024-02-06 11:13 AM
Author

mxell_0-1707235992756.png

 

417 Views
marksouzacosta
Partner - Specialist
Partner - Specialist
‎2024-02-06 11:28 AM

Ah desculpa Mxwell, eu entendi completamente errada a sua questão. Achei que você estava falando de modelagem de dados mas acredito que você esteja falando de criar um gráfico de organograma.

Neste caso, você pode usar o Org chart que fica dentro de Custom Objects > Qlik Visualization bundle.


Aqui o help sobre esse chart e como configurar ele:
Org chart | Qlik Cloud Help

O Yoshida também tem um vídeo sobre isso no canal do YT dele. Vale a pena conferir:
https://youtu.be/bf9Lme8F-q8?si=UcDTO72TZRWMVmrm

Era isso mesmo que você estava procurando?

Valeu,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
398 Views
mxell
Contributor III
Contributor III
‎2024-02-06 02:15 PM
Author

@marksouzacosta 

Perdão pela confusão! Vou tentar ser mais claro.

Hoje eu tenho esse organograma no qlik:

mxell_0-1707246704108.png

 

O idela seria que fosse assim:

mxell_1-1707246774124.png

 

Eliminando esses que estão zerados. Já que eles estão ali somente como uma "gambiarra", para não ficar no mesmo nível de G110000001, G112000000 E G113000000

Já que G111100000, G111200000, G111300000 estão no mesmo nível. E respondem TAMBÉM diretamente a G110000000

 

Ficou claro?

371 Views
marksouzacosta
Partner - Specialist
Partner - Specialist
‎2024-02-06 02:56 PM

Pelo seus dados o Organograma está correto.
G111100000, G111200000, G111300000 respondem diretamente ao G111000000.

Agora, se você quer retirar esse nível intermediário do G111000000 pra conectar os G111100000, G111200000, G111300000 diretamente com o G110000000 eu faria um updated no Load Script pra alterar cod_unid_lotac_filho de G111000000 para G110000000. Mas, isso só seria prático se fosse uma modificação isolada. Existem mais casos parecidos com esses e você quer tipo uma forma automatica de fazer essa modificação?

Read more at Data Voyagers - datavoyagers.net
353 Views