topic Re: Pivot expand problem in QlikView https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783500#M277382 <HTML><HEAD></HEAD><BODY><P>Now I get it. It seems as if the Activity 1 area, whenever collapsed, gets the color of the first actual Activity 1 dimension value.</P><P></P><P>You can use the dimensionality() function to decide whether a dimension cell should be colored or not. See the QV Desktop help (Chart Inter Record Functions-&gt;dimensionality()) which explicitly states that "<EM>A typical use is in attribute expressions, when you want to apply different cell formatting depending on aggregation level of data</EM>."</P></BODY></HTML> Wed, 11 Feb 2015 12:10:36 GMT Peter_Cammaert 2015-02-11T12:10:36Z Pivot expand problem https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783493#M277375 <HTML><HEAD></HEAD><BODY><P>Hi ALL, </P><P>I have the following problem. </P><P>I have a pivot table with colors background in every dimensions. </P><P>when the pivot is collapse, the table looks like the following:</P><P><IMG alt="1 pivot.PNG" class="image-1 jive-image" src="/legacyfs/online/77618_1 pivot.PNG" style="height: 508px; width: 620px;" /></P><P>when I open the second dimension, I can see the colors of all the column although I want to see only the color of the specific row I expanded</P><P><IMG alt="2 pivot.PNG" class="jive-image image-2" src="/legacyfs/online/77619_2 pivot.PNG" style="height: 434px; width: 620px;" /></P><P></P><P>Can someone please advise? Hope I was clear enough </P></BODY></HTML> Wed, 11 Feb 2015 09:09:31 GMT https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783493#M277375 2015-02-11T09:09:31Z Re: Pivot expand problem https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783494#M277376 <HTML><HEAD></HEAD><BODY><P>Both selections (3372 &amp; 3376) are expanded, it seems...</P></BODY></HTML> Wed, 11 Feb 2015 09:14:41 GMT https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783494#M277376 Peter_Cammaert 2015-02-11T09:14:41Z Re: Pivot expand problem https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783495#M277377 <HTML><HEAD></HEAD><BODY><P>only the first dimension, the second dimension is not</P></BODY></HTML> Wed, 11 Feb 2015 09:16:15 GMT https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783495#M277377 2015-02-11T09:16:15Z Re: Pivot expand problem https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783496#M277378 <HTML><HEAD></HEAD><BODY><P>I'm sorry, I'm not following you.</P><P></P><P>What should be colored differently in your second screenshot?</P></BODY></HTML> Wed, 11 Feb 2015 09:22:03 GMT https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783496#M277378 Peter_Cammaert 2015-02-11T09:22:03Z Re: Pivot expand problem https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783497#M277379 <HTML><HEAD></HEAD><BODY><P>the activity 1 field under 3376 shouldn't be white because I didn't expand the "session name" dimension of that row?</P></BODY></HTML> Wed, 11 Feb 2015 09:39:05 GMT https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783497#M277379 2015-02-11T09:39:05Z Re: Pivot expand problem https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783498#M277380 <HTML><HEAD></HEAD><BODY><P>There is no Activity 1 area for 3376-&gt;Health. The Session Name field covers two cells and the double cell is green.</P><P></P><P>[Edit] Wasn't precise enough. Better now.</P></BODY></HTML> Wed, 11 Feb 2015 10:10:34 GMT https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783498#M277380 Peter_Cammaert 2015-02-11T10:10:34Z Re: Pivot expand problem https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783499#M277381 <HTML><HEAD></HEAD><BODY><P>thanks for answering.</P><P>that's not true. you can see in the attached screenshot that this field contain activity 1 after expanding it. </P><P></P><P><IMG alt="3 pivot.PNG" class="image-1 jive-image" src="/legacyfs/online/77631_3 pivot.PNG" style="height: 495px; width: 620px;" /></P></BODY></HTML> Wed, 11 Feb 2015 11:12:37 GMT https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783499#M277381 2015-02-11T11:12:37Z Re: Pivot expand problem https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783500#M277382 <HTML><HEAD></HEAD><BODY><P>Now I get it. It seems as if the Activity 1 area, whenever collapsed, gets the color of the first actual Activity 1 dimension value.</P><P></P><P>You can use the dimensionality() function to decide whether a dimension cell should be colored or not. See the QV Desktop help (Chart Inter Record Functions-&gt;dimensionality()) which explicitly states that "<EM>A typical use is in attribute expressions, when you want to apply different cell formatting depending on aggregation level of data</EM>."</P></BODY></HTML> Wed, 11 Feb 2015 12:10:36 GMT https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783500#M277382 Peter_Cammaert 2015-02-11T12:10:36Z Re: Pivot expand problem https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783501#M277383 <HTML><HEAD></HEAD><BODY><P>Thank you! </P></BODY></HTML> Wed, 11 Feb 2015 13:47:18 GMT https://community.qlik.com/t5/QlikView/Pivot-expand-problem/m-p/783501#M277383 2015-02-11T13:47:18Z