Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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