topic Re: Visualization issue - searching for ideas in QlikView

Visualization issue - searching for ideas

datanibbler — Thu, 26 Jul 2018 19:26:17 GMT

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

Re: Visualization issue - searching for ideas

raviityou — Fri, 27 Jul 2018 07:05:27 GMT

share sample .qvw and expected result if any

Re: Visualization issue - searching for ideas

ogautier62 — Fri, 27 Jul 2018 07:42:07 GMT

Hi,

you could use triggers on your selection box,

with reduction or restauration of your charts according to the selection

regards

Re: Visualization issue - searching for ideas

datanibbler — Fri, 27 Jul 2018 07:46:58 GMT

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

Re: Visualization issue - searching for ideas

datanibbler — Fri, 27 Jul 2018 07:50:32 GMT

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?

Re: Visualization issue - searching for ideas

datanibbler — Fri, 27 Jul 2018 07:52:16 GMT

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.

Re: Visualization issue - searching for ideas

ogautier62 — Fri, 27 Jul 2018 07:56:11 GMT

you are right

Re: Visualization issue - searching for ideas

ogautier62 — Fri, 27 Jul 2018 08:00:03 GMT

maybe use a treillis chart with your kpi as dimension,

it could so adapt size automatically ?

Re: Visualization issue - searching for ideas

datanibbler — Fri, 27 Jul 2018 08:11:12 GMT

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!

Re: Visualization issue - searching for ideas

datanibbler — Fri, 27 Jul 2018 09:02:18 GMT

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.

Re: Visualization issue - searching for ideas

datanibbler — Fri, 27 Jul 2018 10:14:30 GMT

Hmmm ... it would make many things easier if I could just put it all into one single big table_chart.

That would make the dynamism behind it much easier - no need for 4+ overlaid objects with visibility_conditions, but I'd have those conditions only in the expressions - the width of the table would change dynamically and I could put in some blank space (via expressions) inbetween different KPIs and all.

I will try that as well and just ask with what to continue.