topic Pivot table dimensions not showing up in server?! in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-dimensions-not-showing-up-in-server/m-p/735382#M263175 <HTML><HEAD></HEAD><BODY><P>Good Afternoon,</P><P>I have finished creating a small application we have and it has a single pivot table with two dimensions and about 15 expressions.</P><P>Since we have so many expressions I decided to flip the table 90 degrees and have the dimensions on top Y axis, and the expressions on the X axis. I have done so by simply dragging the cells and realigning. It looks great when on my development machine.</P><P>I push this application to the server and now suddenly it is ignoring one of the dimensions. <SPAN style="text-decoration: line-through;">I am confused as to what might be causing this!?</SPAN></P><P></P><P>EDIT: Note that when I tried to remove the dimension that was working, so only one dimension was left the table appeared in the server with no dimensions.</P><P></P><P>EDIT 2: I had suppress when value is null on that main dimension, when i removed it I could see the missing dimension, but ONLY when one dimension is selected. Suspecting that has something to do with it.</P><P></P><P>Edit 3: <STRONG>I now have it working, but it is really weird, I had to select "Show all values" on both dimensions to get it to work. Can someone explain if that's the expected behavior?!</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Note that this is still open as the fix only worked in the QA Environment and not Prod... inconsistent behavior.</STRONG></P></BODY></HTML> Thu, 18 Sep 2014 21:04:07 GMT 2014-09-18T21:04:07Z Pivot table dimensions not showing up in server?! https://community.qlik.com/t5/QlikView/Pivot-table-dimensions-not-showing-up-in-server/m-p/735382#M263175 <HTML><HEAD></HEAD><BODY><P>Good Afternoon,</P><P>I have finished creating a small application we have and it has a single pivot table with two dimensions and about 15 expressions.</P><P>Since we have so many expressions I decided to flip the table 90 degrees and have the dimensions on top Y axis, and the expressions on the X axis. I have done so by simply dragging the cells and realigning. It looks great when on my development machine.</P><P>I push this application to the server and now suddenly it is ignoring one of the dimensions. <SPAN style="text-decoration: line-through;">I am confused as to what might be causing this!?</SPAN></P><P></P><P>EDIT: Note that when I tried to remove the dimension that was working, so only one dimension was left the table appeared in the server with no dimensions.</P><P></P><P>EDIT 2: I had suppress when value is null on that main dimension, when i removed it I could see the missing dimension, but ONLY when one dimension is selected. Suspecting that has something to do with it.</P><P></P><P>Edit 3: <STRONG>I now have it working, but it is really weird, I had to select "Show all values" on both dimensions to get it to work. Can someone explain if that's the expected behavior?!</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Note that this is still open as the fix only worked in the QA Environment and not Prod... inconsistent behavior.</STRONG></P></BODY></HTML> Thu, 18 Sep 2014 21:04:07 GMT https://community.qlik.com/t5/QlikView/Pivot-table-dimensions-not-showing-up-in-server/m-p/735382#M263175 2014-09-18T21:04:07Z