topic Re: Pivot table/ Straight table in QlikView

Pivot table/ Straight table

Thu, 30 Jun 2011 08:19:15 GMT

I have a data structure as below:

But now I want to get a table in qlikview with the following data:

To see if the bestuurder ID in Source 1 is filled in and bestuurder ID in Source 2 is filled in.

Does anyone have a solution for this issue?

deepakk — Thu, 30 Jun 2011 08:30:28 GMT

hi,

Try out the attach application.

Thu, 30 Jun 2011 08:55:16 GMT

Thanks. But this is not the solution for me because in the original structure I have also the field Source.

This is the original dataset:

So in this set it is impossible to make a join in the script. Because I need the field source for another object in my qlikview document.

deepakk — Fri, 01 Jul 2011 02:19:15 GMT

hi,

If you have Source field then what will be final output. Because if you add the source to your output the value will be duplicated.

Deepak