topic Re: Help with Bar Charts in QlikView

Help with Bar Charts

Wed, 12 Nov 2014 16:05:09 GMT

Hello Friends,

I'm new here in Community and I'd like to make a question,

I did the chart below using the assistent,

and when I click in 'SP' for example it shows as the image below

How do I show the cities that belong to the state 'SP' istead of showing just SP data ? I have this field on my table.

Thank You for the Help in advance

Att

Bruno Dantas

Re: Help with Bar Charts

ashfaq_haseeb — Wed, 12 Nov 2014 16:10:27 GMT

Hi,

You need to create a drill down group.

Can you share your sample app?

Regards

ASHFAQ

Re: Help with Bar Charts

Wed, 12 Nov 2014 16:10:43 GMT

Hi Bruno

you have to build a hierarchical group with state and city "documents properties > group > add new group > add fields"

when you click on state it will drill-down to cities

best regards

Chris

Re: Help with Bar Charts

Wed, 12 Nov 2014 16:31:45 GMT

I'll take a look at this 'Drill down Group' and Return to you about that,

Rly tnks for the help

What do you mean with my Sample ? Are you talking about the QWV file?

Re: Help with Bar Charts

Wed, 12 Nov 2014 16:32:09 GMT

Thanks for the help I'll do that and Return to you

Re: Help with Bar Charts

ashfaq_haseeb — Wed, 12 Nov 2014 16:34:08 GMT

Yes share you qwv file.

I'm sure drill down is the solution.

Regards

ASHFAQ

Re: Help with Bar Charts

Wed, 12 Nov 2014 16:41:27 GMT

How do i Host the file here in the Community for you?

I'm Using the personal version of the Qlikview tool , is it possible to open in other machine anyway?

Re: Help with Bar Charts

ashfaq_haseeb — Wed, 12 Nov 2014 16:44:35 GMT

I can open.

Make sure you open this in new window, when you Reply to this post.

On the top right you see use advance editor.

Then you will find an option to attach file in bottom right.

Hope it helps

Regards

ASHFAQ

Re: Re: Help with Bar Charts

Wed, 12 Nov 2014 16:46:31 GMT

Please take a look at the file

Re: Re: Help with Bar Charts

Wed, 12 Nov 2014 16:46:45 GMT

Bruno,

usa o editor avançado e clica em anexar para adicionar o QVW.

Abraço.

Re: Re: Help with Bar Charts

Wed, 12 Nov 2014 16:50:50 GMT

Valeu cara,

postei ali em cima

Re: Re: Help with Bar Charts

Wed, 12 Nov 2014 16:52:08 GMT

Você gostaria de clicar no estado de SP por exemplo, e ele filtrar todas as cidades de SP?

Abraço.

Re: Help with Bar Charts

Wed, 12 Nov 2014 16:53:52 GMT

Isso queria q ele mostrasse uma lista com as cidades do estado (que estão relacionadas na tabela)

Só pra te explicar

Tenho 1 produto que é relacionado por Região e cidade

Queria clicar no estado e ver os produtos e cidades que pertencem,

Comecei a usar a ferramenta a pouco tempo por esse motivo tenho um pouco de dificuldade na técnica de demonstração,

Valeu pela Ajuda Paulo

Re: Re: Re: Help with Bar Charts

ashfaq_haseeb — Wed, 12 Nov 2014 16:53:55 GMT

Check this

Regards

ASHFAQ

Re: Re: Help with Bar Charts

Wed, 12 Nov 2014 16:57:57 GMT

Faz o seguinte, adiciona um grupo na tua dimensão, e neste grupo hierárquico tu poe teu estado e depois cidade.

Substitui o grupo pelo teu campo estado.

Re: Help with Bar Charts

Wed, 12 Nov 2014 16:59:10 GMT

Thank you for the aswer Ashfaq,

I created the group as you showed me now i'll work on it,

Now I want to show in a list what cities belong to 'SP' when I click in SP, I don't know if this is possible but I'll try,

Thank you for the help!

Re: Help with Bar Charts

Wed, 12 Nov 2014 17:31:16 GMT

Valeu cara pela ajuda, consegui aqui.

Re: Re: Help with Bar Charts

Wed, 12 Nov 2014 17:33:10 GMT

Por favor, marca a pergunta como respondida para a resposta que lhe ajudou a resolver o problema.

Abraço.

Re: Help with Bar Charts

Wed, 12 Nov 2014 17:43:15 GMT

Como marco o seu também ?

Tive ajuda sua e do Ashfaq ,

Ou já esta marcada como respondida? Desculpa a inexperiência no fórum