Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Breaks in a Table by Value

Please advise on the following problem.

I have data like this.  I am using Straight Table. 

ContryStateRevenue
USANew York2
USANew York3
USANew Jersey4
MEXICOState15
MEXICOState26

However, I want the data like this.  How can I remove the dupes in the first column ?

ContryStateRevenue
USANew York2
New York3
New Jersey4
MEXICOState15
State26


-Regards.

1 Reply
Highlighted
sivarajs
Valued Contributor II

Breaks in a Table by Value

its better to use pivot table to remove multiple entries of same value