Visualization issue - searching for ideas

[datanibbler]

Hi,

I am facing the following visualization issue:

- I am working on a Management_Dashboard where I have four KPIs to display - a maximum of four, that is:

-- The user can select, out of a list of KPIs that I have on display in a listbox, up to four KPIs to display in both a graph and a table.

-- In addition, the user can select which expressions (there can be up to five, plus one dimension) to display for the KPIs.

=> I currently have a choice of four KPIs, let's say A, B, C and D - for each one I need a table, all side by side if the user selects to view all four <-> if, however, the user wants to see only B, C and D, I want B to take the leftmost place (formerly occupied by A) so that there is no gap - and so on.

The dimension is always the same for all KPIs, so I need to display it in only one of all the tables. The selection of columns to display in the tables is also the same for them all;

<=> Even so, given that I want the tables to always not-quite-touch, without big gaps, and I cannot make them move dynamically, I guess I need a number of tables in the same spot with visibility_conditions. That is going to be quite a maintenance issue lateron ... but first things first, for now I just have to create that.

Do those position boxes (caption tab) take variables? Doesn't seem so ... What a pity.

Any other ideas? I will hang on to this myself and see what I can come up with.

Thanks a lot!

Best regards,

DataNibbler

[raviityou]

share sample .qvw and expected result if any

[ogautier62]

Hi,

you could use triggers on your selection box,

with reduction or restauration of your charts according to the selection

regards

[datanibbler]

Hi,

I am one step further now. Depending on the configuration - the nr. of columns the user chooses to view per table - there may or may not be enough screen_space for four tables side by side - I'm making that interdependent - with a maximum of four columns per table (there is a fifth one for the dimension in the leftmost table only), there is space for four tables - with more than four columns per table, there is space only for three.

In principle, the thing is easy - just a nr. of copies of the same tables (and lateron charts) - the things to display (depending on user_selections) are always the same.

<=> The nr. of copies is just the issue: With both the width of the table and the nr. of tables to display varying, I'll need some of those ...

Best regards,

DataNibbler

[datanibbler]

Hi Olivier,

thanks for the idea! I'm afraid I don't quite get you yet - I don't see the advantage in your proposal yet - whether I add visibility_conditions or I minimize and restore tables according to user_selections - does that make a difference?

[datanibbler]

Somehow I have to make the tables look alike acc. to the width of the columns - unfortunately I don't know of any way that can be really controlled in QlikView. I'll just have to make all the charts copies of the first one.

[ogautier62]

you are right

[ogautier62]

maybe use a treillis chart with your kpi as dimension,

it could so adapt size automatically ?

[datanibbler]

Hi Olivier,

first I will finish the way I see it up to a certain point and then I'll do some experiments with both trellis_charts and combo_boxes. Both won't return exactly what I want - well, the way I see the requirement - but they might be a possibility. I'll make up some proposals and talk about it with my superior.

Thanks a lot!

[datanibbler]

The problem is, every visibility_condition I add to any of the table_charts has to be quite large - it always has to say like "if this is so/ not so and everything else is the same, display this" and so on - the condition always has to take into account all the possibilities ... a lot of potential for optimization by using a dynamic variable that reacts exactly to what is and what is not selected - but first things first, optimization later.