topic Re: Grouping data by measurement and draw multiple line graph in App Development

Grouping data by measurement and draw multiple line graph

Mon, 22 Jun 2015 10:36:15 GMT

Hi all,

I'm new to Qlik Sense. I've data in mongodb. I managed to load data via qvsource.Now, I've data like this.

Name Time Value

Sig0	1434443400061	0.78535046693984389
Sig0	1434365571861	0.47410865876843988
Sig0	1434367800061	0.52816115795111507
Sig1	1434443400062	0.54981022370331589
Sig1	1434365571862	0.48053196850949664
Sig1	1434367800062	0.28258334531262386

Now, i wanted to draw a line graph with

X-Axis -> Time (in local date time)

Y-Axis -> two lines for Sig0, Sig1 and values should plot corresponding to time.

How can i achieve this?

Edit:

sunindia‌ gave a solution which looks promising with Qlik View but i need help with Qlik Sense.

Re: Grouping data by measurement and draw multiple line graph

sunny_talwar — Mon, 22 Jun 2015 10:45:07 GMT

I guess add Time and Name as dimension (in the mentioned order) and use Sum(Value) or Avg(Value) as your expression and it should give you what you are looking for.

Best,

Sunny

Re: Grouping data by measurement and draw multiple line graph

sunny_talwar — Mon, 22 Jun 2015 10:48:03 GMT

Something like this?

Re: Grouping data by measurement and draw multiple line graph

Mon, 22 Jun 2015 11:32:09 GMT

Hi sunindia,

Your snap looks like what i need. can you tell me how to open your .qvw file?

FYI,

I'm using Qlik Sense not Qlik View

Appreciate your support.

Re: Grouping data by measurement and draw multiple line graph

sunny_talwar — Mon, 22 Jun 2015 11:34:32 GMT

I didn't know you were using Sense, I don't think you will be able to open qvw unless you have QlikView. Regardless the idea is to create a chart with Time (1st Dimension) and Name (2nd Dimension) as Dimensions and expression would be Sum/Avg/Max/Min(Value) based on your requirement.

HTH

Best,

Sunny

Re: Grouping data by measurement and draw multiple line graph

Mon, 22 Jun 2015 11:40:32 GMT

sunindia‌ I understood. Can you tell me how exactly handle measurement (value) with combination of another measurement(Name) with respect to time?

is it possible to paste piece of code you used to get that part of drawing logic (Expression in Qlik Sense), if its is a text?

Re: Grouping data by measurement and draw multiple line graph

sunny_talwar — Mon, 22 Jun 2015 12:06:06 GMT

I am not sure what you are trying to ask? Can you explain it a little more?

Best,

Sunny

Re: Grouping data by measurement and draw multiple line graph

Mon, 22 Jun 2015 12:11:39 GMT

sunindia Since you are using QlikView and I'm using QlikView Personal Edition( I'm not able to open a document created using another user's personal edition), I'm trying to understand how to create same at my side using Qlik view Personal Edition or Qlik Sense.

If you can explain me how you created that .qvw file, i wanted to create same at my side.

Hope i'm clear.

Re: Grouping data by measurement and draw multiple line graph

sunny_talwar — Mon, 22 Jun 2015 12:14:57 GMT

Here are the screenshots:

1) Add Time and Name as your dimension

2) Add an expression: I am using Sum(Value)

Does this help clarify things? I hope this will help

Best,

Sunny

Re: Grouping data by measurement and draw multiple line graph

Patrik_Lundblad — Fri, 26 Jun 2015 10:36:02 GMT

Hi Prasad,

Go to the sheet in Qlik Sense,

Drag out a line chart

Drag out the field Time and choose Add "Time"

Drag out the field Name and choose Add "Name"

Drag out the field Value and choose Add as measure and then the option Sum

Then to make it look better you can go into the propert panel on the right hand side and Appearance->Presentation you choose to have missing values represented as connections.

Re: Grouping data by measurement and draw multiple line graph

Fri, 26 Jun 2015 15:27:39 GMT

Hi Patrik, Does this allow for more than two dimensions?

Re: Grouping data by measurement and draw multiple line graph

Patrik_Lundblad — Mon, 29 Jun 2015 06:48:31 GMT

Hi Madhu,

No, the line chart is currently limited to two dimensions.

What's the use case you want to do? Sometimes it's easy to create a second dimension that contains the values additional dimensions would have. Or you could go with multiple measures instead.

Best regards,

Patrik