Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
Partner
Partner

Accessing first column of pivot

Hi together,

I've sorted my customer by ID/Number and Name in a pivot. How can I access or check, whether DB1 or Zahlungsmoral is referencing to the correct customer-No?

I've found no way to get the ID 1000093 from the first column. Because the first column starts at DB1.

And I need the pivot, because a lot customer have more than one customerNumber.

 

pivot.png

I hope you had this issue and could help me in this matter.

Greetings,

Mathias

1 Reply
Highlighted

Re: Accessing first column of pivot

I would suggest load two different tables with different fields from 2 DB's and then check?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)