Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Pericator
New Contributor III

Select most left value in Pivot

Hello,

ist there a way to get the most left value, which is not null, per row in a pivot table? See attached image for example.

 

Thanks in Advance

1 Solution

Accepted Solutions
Pericator
New Contributor III

Re: Select most left value in Pivot

I found a solution:

Total <Date Dimension> 

3 Replies
Highlighted
materi
New Contributor III

Re: Select most left value in Pivot

Pericator
New Contributor III

Re: Select most left value in Pivot

I only got one Table, I dont want to join some other. I want a function on visualization level, which allows me to calculate some other values. And therefore I need the first value in each row. 

Pericator
New Contributor III

Re: Select most left value in Pivot

I found a solution:

Total <Date Dimension>