topic Re: Pivot table in QlikView https://community.qlik.com/t5/QlikView/Pivot-table/m-p/668455#M474724 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This works as expected.</P><P>If you want to remove yellow repeated content. Remove Date from your from your pivot table.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 28 Aug 2014 11:05:43 GMT ashfaq_haseeb 2014-08-28T11:05:43Z Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/668454#M474723 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>This screenshot is of pivot chart which i made, although its half but i hope it ll be clear once i give detailed description.</P><P></P><P>Ive check-boxed the "always fully expanded" so im facing a weird problem, however i tried with un-checking the option but i guess its built in function of pivot table to expand it to its core. Anyway, i was wondering if there was any expression or option through which i could solve this problem. I want no repetition of Milestones[In yellow box] i want it to show distinctly rather than for every planned submit date. and same is for Employees Deployed. </P><P></P><P>The expression of employees deployed is count(Employees Deployed) but whenever i add distinct to it it doesn't show up anything.</P><P></P><P></P><P><IMG alt="pivot.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65473_pivot.PNG.png" style="width: 620px; height: 192px;" /></P></BODY></HTML> Thu, 28 Aug 2014 11:01:58 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/668454#M474723 2014-08-28T11:01:58Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/668455#M474724 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This works as expected.</P><P>If you want to remove yellow repeated content. Remove Date from your from your pivot table.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 28 Aug 2014 11:05:43 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/668455#M474724 ashfaq_haseeb 2014-08-28T11:05:43Z