topic Re: Bar-Line Graph with two expressions and two Dimensions in QlikView

Bar-Line Graph with two expressions and two Dimensions

cristian_av — Thu, 05 Nov 2015 18:16:22 GMT

I want to join this Two graphs in one. How can I do this?

All the data is in one table, and three fields. ie:

CantidadEPCorregido	Sistema Origen Unido	EP
23	Consumo Real	EP1
35	Consumo Real	EP2
40	Tramo 1	EP2
...	...	...

First Graph:

=Sum({¨<[Sistema Origen Unido]={'Consumo Real'}>} CantidadEPCorregido)

Second Graph:

=Sum(CantidadEPCorregido)

If I puth this Two Expressions in one graph, I get the third graph, which loses one of its dimensions.

¿Any idea how to solve this?

Thanks!!

Re: Bar-Line Graph with two expressions and two Dimensions

swuehl — Thu, 05 Nov 2015 22:23:36 GMT

Just to understand, your first graph shows a subset of the second, so why do you want to combine both expressions, since there will not be additional information, or am I missing something?

Which dimensions are you using in your charts? Could you upload a small sample QVW and your expected result (e.g. as excel file or sketch drawing?

Re: Bar-Line Graph with two expressions and two Dimensions

swuehl — Thu, 05 Nov 2015 23:07:28 GMT

Do you maybe want to show the line for Consumo Real regardless of selections in that field? But also lines for the other possible field values?

Then try your two dimensions and a single expression:

=Sum({¨<[Sistema Origen Unido] += {'Consumo Real'}>} CantidadEPCorregido)

Re: Bar-Line Graph with two expressions and two Dimensions

Fri, 06 Nov 2015 01:48:53 GMT

You should try to split the Y axis - primary axis and secondary axis