topic Re: Show Excel File In QLikview in QlikView https://community.qlik.com/t5/QlikView/Show-Excel-File-In-QLikview/m-p/996038#M528771 <HTML><HEAD></HEAD><BODY><P>Please see the attached</P></BODY></HTML> Wed, 26 Aug 2015 06:49:46 GMT Kushal_Chawda 2015-08-26T06:49:46Z Show Excel File In QLikview https://community.qlik.com/t5/QlikView/Show-Excel-File-In-QLikview/m-p/996035#M528768 <HTML><HEAD></HEAD><BODY><P>hello dears</P><P>i want show this file in qlikview</P><P>Look like Excel File (Style,Sort,Group,Status Done=Green And InProgres = Yellow,...)</P><P>Plz Help me</P><P>excel file is attachment</P><P></P><P><IMG __jive_id="96985" alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/96985_Untitled.png" style="height: 159px; width: 620px;" /></P></BODY></HTML> Wed, 26 Aug 2015 05:04:29 GMT https://community.qlik.com/t5/QlikView/Show-Excel-File-In-QLikview/m-p/996035#M528768 2015-08-26T05:04:29Z Re: Show Excel File In QLikview https://community.qlik.com/t5/QlikView/Show-Excel-File-In-QLikview/m-p/996036#M528769 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this.</P><P>Choose Pivot table and in Status dimension. Expand the dimension choose background then type below expression.</P><P></P><P>if(Status='Done',Green(),Yellow())</P></BODY></HTML> Wed, 26 Aug 2015 05:47:22 GMT https://community.qlik.com/t5/QlikView/Show-Excel-File-In-QLikview/m-p/996036#M528769 krishna20 2015-08-26T05:47:22Z Re: Show Excel File In QLikview https://community.qlik.com/t5/QlikView/Show-Excel-File-In-QLikview/m-p/996037#M528770 <HTML><HEAD></HEAD><BODY><P>Import File Look Like Excel File</P></BODY></HTML> Wed, 26 Aug 2015 05:53:08 GMT https://community.qlik.com/t5/QlikView/Show-Excel-File-In-QLikview/m-p/996037#M528770 2015-08-26T05:53:08Z Re: Show Excel File In QLikview https://community.qlik.com/t5/QlikView/Show-Excel-File-In-QLikview/m-p/996038#M528771 <HTML><HEAD></HEAD><BODY><P>Please see the attached</P></BODY></HTML> Wed, 26 Aug 2015 06:49:46 GMT https://community.qlik.com/t5/QlikView/Show-Excel-File-In-QLikview/m-p/996038#M528771 Kushal_Chawda 2015-08-26T06:49:46Z