Create a table that is dynamic with the columns in qlik sense

[Anonymous]

Hi,
Im very new to qlik sense. If I have data like this. 

Person	Date/Iteration	Distance	Passed 5000
A	1	5000	Yes
B	1	5000	Yes
C	1	5000	Yes
D	1	4000	No
E	1	6000	Yes
A	2	7000	Yes
B	2	3000	No
C	2	2000	No
D	2	5000	Yes
E	2	5000	Yes

Can I present this in qlik sense like this below?

Person/Iteration	1	2	3	4	5
A	"Passed 5000? as a result here i.e. "Yes	Yes
B	Yes	No
C	etc
D
E

thanks!

[YoussefBelloum]

Hi,

on the second table, what is the calculation rule of the column 1 and what is the column 2 ?

[Anonymous]

First column is the person, second would be the "Date/iteration" column, but I want that column to be expanded as a row since it has multiple values. As you say I would need some calculation display the values of the "Passed 5000" values. I haven't looked into the details since I haven't figured out if it is possible or not.

[YoussefBelloum]

I think you're trying to pivot your "date/iteration" column.. you should be able to do this using a pivot table

[Anonymous]

That seems to give the correct structure. But how do i populate the table with the result of "Passed 5000"? Now I have:

Person    Date1   Date2

A             1             2

[Digvijay_Singh]

This may help, generic load is used to convert one column values into separate columns -

The Generic Load