topic Problem with Charts in QlikView

Problem with Charts

volcore79 — Tue, 16 Nov 2010 14:22:02 GMT

Hi,

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.

Regards

Volker

Problem with Charts

Tue, 16 Nov 2010 15:42:49 GMT

Hi Volker,

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.

Regards, Roland

Problem with Charts

volcore79 — Tue, 16 Nov 2010 15:58:09 GMT

Do you have an idea how to put them together in one field ? the excel files can be changed..

Problem with Charts

Tue, 16 Nov 2010 16:20:20 GMT

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.

Problem with Charts

volcore79 — Tue, 16 Nov 2010 16:22:58 GMT

I don't get it. Could you change the example file and send it back to me ?

Problem with Charts

Tue, 16 Nov 2010 17:43:19 GMT

Hi again,

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.

AW:Re: Problem with Charts

volcore79 — Wed, 17 Nov 2010 09:09:43 GMT

Manchmal ist die Lösung so einfach, dass man selbst nicht darauf kommt...

That's it !! Thanks a lot!

Volker