topic Is this possible to make? in QlikView

Is this possible to make?

Tue, 14 Jun 2011 19:29:50 GMT

Hi ,

You can see the above picture...this is something what I am looking forward to create.

3 different list box containing department name. Now what I want is :

1) when you select different department name...from different list box, ( I dont know if that s possible or not) then the following race and age graph should display value corresponds to the selections.

This way you can compare 3 different departments easliy based on age and race based analysis ( I want to give user max of 3 selections).

2)The charts are identical , i mean those are just 2 copies of age and race based chart. Is there a way to selct 3 different department names from 3 diff list boxs on a same sheet??

Well , the trellis function is not something I want.

Any alternative solution would be appreciated.

Thank you so much.

Best,

Yaman

Is this possible to make?

Tue, 14 Jun 2011 21:03:13 GMT

In script, replicate the base table for list into 3 different tables ( different table name and qualify the columns). In UI build 3 list boxes and 3 charts from 3 tables. SInce, the tables are not connected, list boxes will not be linked.

But list boxes and corresponding charts will be linked as they will b from same table.

Is this possible to make?

Tue, 14 Jun 2011 22:58:37 GMT

Hey thanks for replying. But this way I have to load data 3 times(same data)..which is a bit time consuming..anyway thanks a lot for the answer....!!

Re: Is this possible to make?

Tue, 14 Jun 2011 23:47:39 GMT

you have to load the data once from the source. Later, you can use resident load to load other 2 tables. This should be faster.

Re: Is this possible to make?

Tue, 14 Jun 2011 23:51:29 GMT

hey ..I am sorry I don't know the concept of Resident load?? Can you please elaborate..?

Also, I am trying loading the data..i mean replicating the data...but I have created an interval range..which uses AGE field of my data...but now as my data is replicated ..and so is everything...!!

So how can i reference the variable of my 2nd table(replicated one) ...i.e can I use something like 'Table2.AGE' to reference the variable of 2nd table...i tried this...butits not working...??

Re: Is this possible to make?

johnw — Wed, 15 Jun 2011 00:21:30 GMT

John Witherspoon wrote:
Why do you need three different list boxes? If you want them to select three departments to compare, just have them select three compartments to compare. There's no need for separate list boxes, which just complicates things.
And why do you say "the trellis function is not something I want"? Looking at the picture you posted, the trellis function is EXACTLY what you want.
See attached and below.

From the other thread you made on the same subject.

http://community.qlik.com/thread/29698