Show Excel File In QLikview

[#1]

hello dears

i want show this file in qlikview

Look like Excel File (Style,Sort,Group,Status Done=Green And InProgres = Yellow,...)

Plz Help me

excel file is attachment

[krishna20]

Hi,

try this.

Choose Pivot table and in Status dimension. Expand the dimension choose background then type below expression.

if(Status='Done',Green(),Yellow())

[#3]

Import File Look Like Excel File

[Kushal_Chawda]

Please see the attached