topic Create a pivot/summary table in script? in QlikView

Create a pivot/summary table in script?

kkorynta — Wed, 20 Apr 2011 20:09:16 GMT

Hello,

Here's the table I created in excel that I am trying to replicate the format in qlikview:

Here's what I have in Qlikview so far:

As you can see, I'm able to use objects as a means of getting those values. My dilemma is, I need to use these frequency values to run other sets of analysis (such as creating a scatter plot charts displaying leads created vs 0 to 30 days). Is there a way to replicate this effect in the script? Perhaps the other approach would be to reference to the column in the object?

Thanks

Create a pivot/summary table in script?

kkorynta — Wed, 20 Apr 2011 20:12:29 GMT

I'm sorry, it looks like those pictures did not load properly. Here they are:

Create a pivot/summary table in script?

johnw — Wed, 20 Apr 2011 23:00:18 GMT

It looks like you just want to put the "Leads Created" into the main chart? I think you could do it with a calculated dimension like this:

aggr(count(Lead),CreatedDate)

Or whatever your actual field names are. I wouldn't do that counting in the script - too inflexible, not responsive to selections, and so on.

Create a pivot/summary table in script?

kkorynta — Thu, 21 Apr 2011 17:09:47 GMT

Alright, that's a great start.

The onto the next part of the question - how do I go about referencing the values (summations/counts) to create a graph based off of those values?

For example, I'd like to be able to create a scatter plot chart displaying leads (on y axis) and and the age bucket (0 to 30 days) on the x-axis. So the plot points should be

(16,30), (79,68), (70,78), (63,75)... and so forth.

Create a pivot/summary table in script?

kkorynta — Fri, 22 Apr 2011 18:35:17 GMT

Afternoon folks, anyone have any suggestions?

Create a pivot/summary table in script?

johnw — Tue, 26 Apr 2011 23:59:46 GMT

I'm not thinking of a good way. Maybe if you could post a sample data set with an inline load? Then I'd have something to play with. As is, I'm just not sure what your data model looks like, and I'm not going to want to type in all that data by hand anyway.