Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
TestingForTestPurposes
Partner - Contributor
Partner - Contributor

Complex Dimensions in Pivor Table

Hi all,

Within an pivot table I want to calculate sums from one dimension based on several criteria you can see below.

  Dimension3='A' Dimension3='C' or 'B'
Dimension1 ='A' and Dimension2 = 'B' SUM(Dimension4) SUM(Dimension4)
Dimension1 ='' SUM(Dimension4) SUM(Dimension4)
Dimension1 ='D' SUM(Dimension4) SUM(Dimension4)

 

The given input data could like shown below:

Dimension1

Dimension2 Dimension3 Dimension4
A A   10
B     10
C B   10
  C C 10
A B A 10
A B C 10

 

How can I built such a table and how can I display a row filterred for one value of a dimension, even if this dimension does not take on this value?

Labels (5)
4 Replies
henrikalmen
Specialist
Specialist

Could you give an example of what you expect the resulting output to be?

TestingForTestPurposes
Partner - Contributor
Partner - Contributor
Author

Of course! Please see the "result" table below:

  Dimension3='A' Dimension3='C' or 'B'
Dimension1 ='A' and Dimension2 = 'B' 10 10
DImension1 ='' 0 10

 

 

marcus_sommer

For me it's not clear what do you trying to achieve. Means which raw-data have which values and should be lead to which results by which calculations and why? I have the impression that you want to associate the data within the UI. It will be possible in many cases but it's not recommended because it's much harder as doing the essential work in the data-model.

If a data-model is properly built you have just simple expressions like sum(Value) and the object-dimensions and the applied selections are showing automatically the right associations with the wanted results and views.

henrikalmen
Specialist
Specialist

I don't understand your dimension headlines. What does "Dimension3='C' or 'B'" mean? I would like to see input table (raw data) and output table (expected result).