topic Pivot table with many expressions - problem with a total in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-with-many-expressions-problem-with-a-total/m-p/186164#M50383 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P>I have a pivot table with 2 dimensions (Types and Periods) and 9 expressions (a bit mad). It looks something like this:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3369_sourceID:3369" /></P><P>My problem is I want to add another expression, that is relative only to one of the dimensions and not to the Type dimension - the red Expression X. Tried and didn't work:</P><P>- Artificial Type 4 for the red Expression X. In this case I couldn't hide the other 9 expressions I don't want for Type 4</P><P>- Expression with if (dimensionality()=0, calculate me this). In this case I get my calculated Expression X for all types and when dimensionality=2.</P><P>Currently I am trying to create a little 1-row table, that I can stick up to the big table, but it doesn't seem like the best solution. I am doing this for a printed report, so no users are going to click anywhere.</P><P>Do you have any ideas for a workaround?</P><P>Thanks in advance!</P><P>Gizela</P></BODY></HTML> Wed, 26 Jan 2011 14:11:26 GMT 2011-01-26T14:11:26Z Pivot table with many expressions - problem with a total https://community.qlik.com/t5/QlikView/Pivot-table-with-many-expressions-problem-with-a-total/m-p/186164#M50383 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P>I have a pivot table with 2 dimensions (Types and Periods) and 9 expressions (a bit mad). It looks something like this:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3369_sourceID:3369" /></P><P>My problem is I want to add another expression, that is relative only to one of the dimensions and not to the Type dimension - the red Expression X. Tried and didn't work:</P><P>- Artificial Type 4 for the red Expression X. In this case I couldn't hide the other 9 expressions I don't want for Type 4</P><P>- Expression with if (dimensionality()=0, calculate me this). In this case I get my calculated Expression X for all types and when dimensionality=2.</P><P>Currently I am trying to create a little 1-row table, that I can stick up to the big table, but it doesn't seem like the best solution. I am doing this for a printed report, so no users are going to click anywhere.</P><P>Do you have any ideas for a workaround?</P><P>Thanks in advance!</P><P>Gizela</P></BODY></HTML> Wed, 26 Jan 2011 14:11:26 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-many-expressions-problem-with-a-total/m-p/186164#M50383 2011-01-26T14:11:26Z