Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hejpadig
New Contributor

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

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

PersonDate/IterationDistancePassed 5000
A15000Yes
B15000Yes
C15000Yes
D14000No
E16000Yes
A27000Yes
B23000No
C22000No
D25000Yes
E25000Yes

Can I present this in qlik sense like this below?

Person/Iteration12345
A"Passed 5000? as a result here i.e. "YesYes
BYesNo
Cetc
D
E

thanks!

5 Replies
YoussefBelloum
Esteemed Contributor

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

Hi,

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

hejpadig
New Contributor

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

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
Esteemed Contributor

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

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

hejpadig
New Contributor

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

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
Honored Contributor III

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

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

The Generic Load

Community Browser