Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Thank you. Hasn't quite solved my problem entirely but definately useful to know! Thank you very much!
Darren
As I understand your data structure, each call can be linked to more than one call categaory. Is that correct?
Jonathan
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