topic Correlation Help in QlikView

Correlation Help

Sat, 16 Oct 2010 09:44:14 GMT

Hello,

I have the following data structure...

TABLE: Calls

CallID (PK unique)

CallDate

CallTime

CallLength

....

TABLE: CallCategories

ID (PK)

CallID (FK)

CategoryName

Every call is linked by a one-to-many relationship with the CallCategories table via the field 'CallID'

I want the user to be able to select a category from a list and display in a chart, split by category, how many calls fall into the selected category and into each of the other categories.

I've tried a few things but nothing seems to work due to the way QlikView applies the filter. Can anyone help?

Correlation Help

Sat, 16 Oct 2010 11:07:59 GMT

If i understand well, you want to display a chart independant of the selection.

You can try

Dimension = CategoryName

Expression = count( {1} CallID) {1} prevent the filter of the selection

There are after several difficulties, depending of what you want :

- how to find out the selection in the chart ?

- how to take account other filters like a periode ?

to do this, you should have a look at set analysis.

good luck

JJJ

Correlation Help

Sat, 16 Oct 2010 14:12:16 GMT

Thank you. Hasn't quite solved my problem entirely but definately useful to know! Thank you very much!

Correlation Help

jonathandienst — Sat, 16 Oct 2010 18:23:42 GMT

Darren

As I understand your data structure, each call can be linked to more than one call categaory. Is that correct?

Jonathan

Correlation Help

Mon, 18 Oct 2010 07:05:13 GMT

Hi Jonathon,

Yes, thats right. I did have a many-to-many relationship initially (with a bridging table between calls and call category tables) but thought it would be easier to flatten that out and use a one-to-many table structure instead. So basically I want to take all of CallID's that are in the current selection (and the current selection may include one or more categories), and display a count of those CallID's split by the other categories that they are related to. Is it possible...? I've had a look at the Set Analysis topics in the QlikView help files but I'm not much better off...

Thank You

Darren