Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-07-16 07:58 AM

Show only first row in the Second Dimension of a Straight Table

I have a straight table with two dimensions.

For each row in the first dimension, I would like to show only the first row in the second dimension.

For instance, let say I have the dimensions ACCOUNT and TRANSACTION, with several TRANSACTIONS per ACCOUNT

ACCOUNT          TRANSACTION         

Acc1                  T1

Acc1                  T2

Acc1                  T3

Acc2                  T5

should be displayed as

ACCOUNT          TRANSACTION         

Acc1                  T1

Acc2                  T5

I want to achieve so using an expression in a calculated dimension or an option for the sheet object

1,478 Views
0 Likes
10 Replies
Not applicable
‎2014-07-16 09:45 AM
Author

In response to mahesh_agrawal

I cannot see the .qvw. Would you like to describe briefly the content ?

101 Views
0 Likes