topic Re: How to remove Blank space from expression in pivot table? in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-Blank-space-from-expression-in-pivot-table/m-p/111840#M17400 <HTML><HEAD></HEAD><BODY><P>Can you share the sample application </P></BODY></HTML> Tue, 07 Aug 2018 05:59:29 GMT qlikviewwizard 2018-08-07T05:59:29Z How to remove Blank space from expression in pivot table? https://community.qlik.com/t5/QlikView/How-to-remove-Blank-space-from-expression-in-pivot-table/m-p/111839#M17399 <HTML><HEAD></HEAD><BODY><P>Hiii All,</P><P></P><P>Required OutPut:</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/210055_Capture.PNG" style="height: 367px; width: 620px;" /></P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fig 1</P><P></P><P>Qlikview Output:</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/210059_Capture1.PNG" style="height: auto;" /></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fig 2</P><P>I don’t want blank row in between the project numbers as shown in fig 1.can u please help me is there any way to suppress the blank space and get the output in required formet.<SPAN style="font-size: 13.3333px;">Thanks in advance.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Regards,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Hamza</SPAN></P></BODY></HTML> Tue, 07 Aug 2018 05:41:22 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Blank-space-from-expression-in-pivot-table/m-p/111839#M17399 hamzabob1 2018-08-07T05:41:22Z Re: How to remove Blank space from expression in pivot table? https://community.qlik.com/t5/QlikView/How-to-remove-Blank-space-from-expression-in-pivot-table/m-p/111840#M17400 <HTML><HEAD></HEAD><BODY><P>Can you share the sample application </P></BODY></HTML> Tue, 07 Aug 2018 05:59:29 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Blank-space-from-expression-in-pivot-table/m-p/111840#M17400 qlikviewwizard 2018-08-07T05:59:29Z Re: How to remove Blank space from expression in pivot table? https://community.qlik.com/t5/QlikView/How-to-remove-Blank-space-from-expression-in-pivot-table/m-p/111841#M17401 <HTML><HEAD></HEAD><BODY><P>Hii arjun thanks for your rpl..</P><P></P><P>PFA..</P></BODY></HTML> Tue, 07 Aug 2018 06:22:20 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Blank-space-from-expression-in-pivot-table/m-p/111841#M17401 hamzabob1 2018-08-07T06:22:20Z Re: How to remove Blank space from expression in pivot table? https://community.qlik.com/t5/QlikView/How-to-remove-Blank-space-from-expression-in-pivot-table/m-p/111842#M17402 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/hamzabob1">hamzabob1</A></STRONG></P><P>Can you attach the same data as shown in the EXCEL screen data?</P></BODY></HTML> Tue, 07 Aug 2018 06:37:18 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Blank-space-from-expression-in-pivot-table/m-p/111842#M17402 qlikviewwizard 2018-08-07T06:37:18Z Re: How to remove Blank space from expression in pivot table? https://community.qlik.com/t5/QlikView/How-to-remove-Blank-space-from-expression-in-pivot-table/m-p/111843#M17403 <HTML><HEAD></HEAD><BODY><P>PFA.</P></BODY></HTML> Tue, 07 Aug 2018 07:46:48 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Blank-space-from-expression-in-pivot-table/m-p/111843#M17403 hamzabob1 2018-08-07T07:46:48Z