Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mukthasoumya
Contributor II
Contributor II

Show duplicate rows

Hi 

 

Am having the below Problem

I need to show duplicate rows in the data and for that i added rowno but i need to hide the rowno column.

 

LOAD * INLINE [

rowno, Category, Category_desc

1, A, Cat1

2, B, Cat2

3, C, Cat3

4, D, Cat4
5, D, Cat4

];

 

I need to show below in the table

A, Cat1

B, Cat2

C, Cat3

D, Cat4

D, Cat4

 

Thanks in Advance

3 Replies
Vegar
MVP
MVP

Maybe you could "hide" the rowno inside the description value?

Instead of using solely the description value field, create a dual value dimension with the two like this.

Dual(rowno, Category_desc)

mukthasoumya
Contributor II
Contributor II
Author

There is no option to hide in the table in qliksense. I don't have extension support my office

 

 

 

 

mukthasoumya
Contributor II
Contributor II
Author

I mean I don't see option to hide.

Can you give me a screenshot or place to find the hide option