Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show Excel File In QLikview

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

Untitled.png

3 Replies
krishna20
Specialist II
Specialist II

Hi,

try this.

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

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

Not applicable
Author

Import File Look Like Excel File

Kushal_Chawda

Please see the attached