Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot chart dimension union of fields

We try to add one (and only one) dimension to a pivot chart that shall show data from two fields
named KG.SC_text7 and WRV.SC_Text7. The fields are in different tables.
The outcome shall be that the content of the dimension is the union of the content of the fields.

One idea to do this was to add a link table with all values of the fields.
This resulted in a circular reference because of the already existing star scheme.
So this does not work.

Now the question is if it is possible to unite the fields in this pivot chart dimension
by some special expression (set analysis?) or is there any other way to get it done.
Do we have to rework the data model?

The version used is QV 11.2 SR 8.

Thanks a lot.

1 Solution

Accepted Solutions
Not applicable
Author

The answer to this question is that you have to rework the data model and bring these fields together into one table as one field.

It is for sure possible to build a link table referencing to %Fahrzeug including the values of KG.SC_Text7 and WRV.SC_Text7. You will have a proper selection in the pivot chart.

Finally it turns out that the selection will not work properly when you aggregate data from two different branches of the star scheme. This is because the selection does not exclude enough values. The result is that there are wrong sums.

View solution in original post

3 Replies
petter
MVP
MVP

Could you share a screenshot of your data model to us?

Not applicable
Author

Thanks for looking at it.

DataModel-RelevantPart.PNG

Not applicable
Author

The answer to this question is that you have to rework the data model and bring these fields together into one table as one field.

It is for sure possible to build a link table referencing to %Fahrzeug including the values of KG.SC_Text7 and WRV.SC_Text7. You will have a proper selection in the pivot chart.

Finally it turns out that the selection will not work properly when you aggregate data from two different branches of the star scheme. This is because the selection does not exclude enough values. The result is that there are wrong sums.

View solution in original post