Thanks for the feedback.
I am not sure that an extension is the solution to my problem, because end-users always ask additional functionalities.
It would be more helpful, if you could help me understand the parallel coordinates chart, and to help me get the dimensions on the X axis. Here I am completely clueless.
In addition, I did not see an example in the links you sent me (only the description of the extension).
Looking forward to hearing from you.
The extension .QAR and a sample .QVW with the extension is in the blog. Below is a paste of the links in the blog and the resulting QVW screenshot below that.
As for a 'parallel coordinates chart' i have seen an out of box example that uses a 'line chart' in the 'Customer Mix' tab of the qlikview insurance demo here:
The technique for this chart is quite involved but it is 'out of box'.
I'll look it up in detail later.
Now I need confirmation in regard to this:
- it seems to me that the parallel coordinates chart HAS to have the following and ONLY the following building blocks:
and 1 expression.
The first of the two dimensions is for the values on th X axis. The second dimension is for the Y axis.
AND it seems to me important to state that we will have so many Y axis (with values from second dimension) as there are different values on the x axis.
Calculation of the expression is made for the combination (Value on the X axis, value on the Y axis). Depending on that the it is positioned on the Y axis.
This is done for every Y axis and the SAME Y values on every Y axes are connected.
Is this correct?
Not sure i completely follow but it sounds roughly accurate.
For the 'CustomerMix' example , its more complex and here is what the properties look like to adapt the line chart accordingly. For both of these i would suggest working with the samples directly. To be clear I am merely opening up the examples and exploring them myself in order to answer your questions.
If you haven't already, check this out. It is easy to implement and works well. Note that this chart does not work well prior to 11.2 SR4.
This is a qvw derived from this site: qvdesign.wordpress.com/2012/01/31/brilliant-qlikview-parallel-co-ordinates-chart/
ParallelCordinates.qvw 176.5 K
Thanks for your reply - it is very helpful.
The problem I am having with your chart is that it is always necessary to manually select the dimensions.
Would it be possible to make that ONLY two dimensions are always displayed on the X-axis?
If yes, do you maybe know how?
UPDATE - OK - this is solved by deleting calculation condition in 'General' tab.
My next question is - could you please explain the first expression in the 'Expression Tab'?
(The name of the expression is 'Parallel coordinates chart (generic expressions)')
What does it do, and why does it put '%' signs?
The thing is - what I want my chart to do is only to take the values contained in the first dimension (M2) and connect them with the corresponding values in the second dimension (M5)
So for example, if my table looks something like:
the chart looks in this phase as follows:
M2 = Expected_Speed_Download_NUM
M5 = Measured_Speed_Download_NUM
The line calculation should be as follows:
for the dimension M2 take the values you find in the table in the column 'M2'.
Do the same with M5.
So only the values have to be taken, without any transformations.
Any suggestion on how to do this?