Help for data representation.

[#1]

Hi All,

I am new in Qlikview Development so bare with me.

I need the help on following activity !

Input :-

Task	Date	status
aa	11/11/2011	Pass
bb	11/11/2011	fail
cc	11/11/2011	Pass
aa	11/12/2011	fail
bb	11/12/2011	Pass
cc	11/12/2011	fail

OutPut:-

Task	11/11/2011	11/12/2011
aa	Pass	fail
bb	fail	Pass
cc	Pass	fail

Thanks,

D J

[marcus_malinow]

Hi Dhiraj,

this looks like an ideal candidate for a pivot table.

Dimensions are Task and Date, and the expression would perhaps be Only(status).

Marcus

[jvitantonio · Accepted solution]

Hi,

Check thre file attached with the solution.

JV

BI Experience | A place to share our Business Intelligence experiences