the attached zip-file contains 3 files: 1 qvw and 2 excels. In the qvw you'll find 9 charts. The first row of charts displays the data of the excel file "Magazin_Umfrage.xlsx". The second row of charts displays the data of the excel file "TDS_Umfrage.xlsx". The third row of charts displays the data of both other rows - but this doesen't work.
How do i get these points to work ?
(1) If i select a "Teilnehmer" every of the 3 "Teilnehmer"-charts (left row) will "change"
(2) The charts in the third row show what they have to show: The results of the charts over it.
take a look at what I did with the field Teilnehmer. When creating a new field $Teilnehmer_ID in the two corresponding tables I linked both together (Note that this is a qick approach!). Search for //RK to follow my data modelling in the script. I am sure this points into the right direction.
I was playing with your application for a while. There are some questions: When choosing a Teilnehmer from your first chart (left in first line) no single other chart is involved. Is this correct ? Shouldn't response at leat the two other Teilnehmer-Charts? This depends on your data modell and I wonder if you want it really that way. When I choose a Teilnehmer from your listbox only the Teilnehmer-chart left middle is changeing. The reason is clear as left upper and left middle chart have different and independent fields as dimension. It seems that your application doesn't work 100% as you wrote in your post. I think we should start to think about your two Teilnehmer-fields, if you can (must) put them together in one field.
It depends on what you want. I.E. When using the same column name during load QV links two (or more) tables together. Like it did with TDS_eigen_Nr. Next could be to try explicitly the join statement together with the load statement.
take a look at what I did with the field Teilnehmer. When creating a new field $Teilnehmer_ID in the two corresponding tables I linked both together (Note that this is a qick approach!). Search for //RK to follow my data modelling in the script. I am sure this points into the right direction.
