topic Re: Line Chart showing list box selection seperatly in QlikView

Line Chart showing list box selection seperatly

Mon, 12 Jan 2015 14:53:26 GMT

Hello

i am new to QV and having some problems regarding charts.

Here's the situation:

I am comparing values of power from different machines. To visualize the data I want to use a Line Chart, which displays the different power values through time.

So I have a list box witch contains all machines. What I want to achieve is, that the chart shows every power line for every machine seperatly, if nothing is selected in the list box. When the user makes a selection, the power values from the selected machine should be displayed. If the user selects more machines, the line chart should display the values for every machine seperatly.

At the moment the line chart shows the cummulated values of the user's selection.

Each machine has an seperate Excel-File which looks like this:

Machine Name	Time	Power Value
Machine1	0.1	668
Machine1	0.2	756
...	...	...

I hope you can help me.

With kind regards,

Alex

Re: Line Chart showing list box selection seperatly

agomes1971 — Mon, 12 Jan 2015 14:56:48 GMT

Hi,

it's more simple to attache your qvw source...

Regards

André Gomes

Re: Line Chart showing list box selection seperatly

Mon, 12 Jan 2015 15:03:26 GMT

I attached my .qwv file. If you need more please tell me

Re: Line Chart showing list box selection seperatly

Gysbert_Wassenaar — Mon, 12 Jan 2015 15:06:53 GMT

Add Time as the first dimension, Machine Name as the second dimension and sum(Power Value) as expression.

Re: Line Chart showing list box selection seperatly

Mon, 12 Jan 2015 15:12:23 GMT

Thank you very much. That is exaclty what I wanted

Greetings