topic Automatically generate one graph by fieldvalue in QlikView

Automatically generate one graph by fieldvalue

Tue, 15 Nov 2011 11:04:03 GMT

Hi,

here is my problem.

I have one field "building", containing 5 values (5 different buildings), and another field "room", with many rooms (containing all the rooms in each of the 5 buildings). Once one building is selected, I would like to generate in a container one combo chart for each room that does exist in the selected building.

How can I do that?

Many thx in advance.

Automatically generate one graph by fieldvalue

jagannalla — Tue, 15 Nov 2011 11:36:41 GMT

For my understanding your data will look like this.

Building, Room

A, 1

A, 2

A, 3

B, 1

B, 2

B, 3

C, 1

C, 2

C, 3

Is it right means. Take in dimesion as Room and expr as Count(Building)

Automatically generate one graph by fieldvalue

Tue, 15 Nov 2011 11:49:42 GMT

Hey,

What i got from your explaination is:

1. You can just use getselectedcount(Building)>0 in the layout condition of container which would make the container visible when a building is clicked.

2. Then just create a combo inside the container having Building in the dimension and No. of Rooms in the Expression.

Hope this would help you.

Regards,

Neelam Singh

Automatically generate one graph by fieldvalue

Tue, 15 Nov 2011 14:46:32 GMT

Well, in my graph, I want to show something else, so for example, the expression would be 'electrical consumption' over dimension 'time'. So to answer Jagan, I would more have something like:

Building, Room

A, 1

A, 2

A, 3

B, 1bis
B, 2bis

C, 1ter
C, 2ter
C, 3ter
C, 4ter

(just to know that 1 for B or C are not the same than for A). But this is only for the choice of graphs. Thus, if I previously choose building A, I will have 3 graphs, 1, 2 and 3. Etc.

Hope that's clear enough.

Automatically generate one graph by fieldvalue

Thu, 17 Nov 2011 08:46:24 GMT

Still nobody with a magical idea? ^^