Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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 |
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 |
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.
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
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
Perdão pela confusão! Vou tentar ser mais claro.
Hoje eu tenho esse organograma no qlik:
O idela seria que fosse assim:
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?
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?