Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

HIERARCHY with all values

In English:

Hi people!!

I have a question:

Im atached a qlikview sample with an excel with 2 sheets:

The first sheet has a sample tree countrys and the second sheet has information for petitions. I have a website to search for hotels for my clients  and I save the destinations that they search and the number results its returned.

PetIdZonIdClientRes
147735A1

The client A search searched for the area Mallorca (47735) and the web return 2 results

I need in qlikview all zones with all clients who have never searched

Thanks!!!

En Español:

Hola gente!

Tengo una pregunta

Adjunto un qlikview con un excel con 2 hojas.

El primer excel tiene un ejemplo de arbol de zonas y la segunda tiene información sobre peticiones. Tengo una web para buscar hoteles a mis clientes y guardo los destinos y el numero de resultados que les he devuelto.

PetIdZonIdClientRes
147735A1

El cliente A ha buscado para mallorca (47735) y ha devuelto 2 resultados.

Necesitaría en qlikview saber en que zonas los clientes nunca me han buscado

Muchas Gracias

Tags (1)
2 Replies

Re: HIERARCHY with all values

See attached qvw


talk is cheap, supply exceeds demand
Not applicable

Re: HIERARCHY with all values

Very Thanks for the solution, but I have a new problem: I have a lot of zones and lot of petitions. And creating the graph needs 5 minuts.

Another idea???

Community Browser