Merging two different base_data_lists (Excel)

datanibbler — Wed, 05 Feb 2014 15:08:49 GMT

Hi,

in the app I'm currently working on, there is a new list for the base_data this year which is largely the same as the one last year, but it's different in details.

- With most KPIs I'm displaying in the app, it was possible to load the data from both lists in one chart.

<=> With the current one, the new list is more detailed in a way that seems to make it impossible to do so:

- Generally speaking, I have a nr._of_cases_opened and a nr_of_cases_closed

- In the old list, the nr_of_cases_opened was differentiated by area, but the nr_of_cases_closed was not

=> I created a basic BAR CHART (with segments stacked) for the cases_opened and for cases_closed I did not assign
any graphical representation, but merely a figure on the axis

     - In the new list, both nrs are differentiated by area
     => I would like to stack the cases_opened and the cases_closed, but keep those two groups separate.
     => To do that, I think I have to use a COMBO CHART and a second dimension

<=> With a second dimension that can be used only with this year's data, but not with last year's data, how am I going to display
both lists in one diagram?

Can anyone help me here?

Best regards,

DataNibbler

Re: Merging two different base_data_lists (Excel)

datanibbler — Thu, 06 Feb 2014 09:25:40 GMT

Hi,

I think I'm going to try just making two distinct diagrams and setting up a visibility condition for both of them.

The chart for this year has become quite complex already - I need a combo_diagram and to get QlikView to stack segments like it would in a bar_chart, but in two groups, I need a second (or, in my instance, third) dimension - I have five aread, so five segments, so I need 20 formulas - 5 for the "opened" cases, 5 for the "closed" and the same again for the other dimension "month" (aggregated values or avg)

Best regards,

DataNibbler

topic Merging two different base_data_lists (Excel) in QlikView

Merging two different base_data_lists (Excel)

Re: Merging two different base_data_lists (Excel)