Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to display value only once using a pivot table for a column?

Hi, We have a requirement as to display the value of column only once . Could you please let me know how to avoid repetitive values.  Auto should be displayed only once under customer Vertical. 

Customer VerticalyearTatal amount
Auto2016100k
Auto2017200k
Auto2018250k
Auto2019400k
Auto2020500k
   
4 Replies
Highlighted
MVP
MVP

Did you try creating pivot table? Pivot table shows values once.

Highlighted
Contributor
Contributor

Yes, we used it in pivot table.
Highlighted
MVP
MVP

would you be able to share sample?

Highlighted
Contributor
Contributor

Customer VerticalyearTatal amount
Auto2016100k
 2017200k
 2018250k
 2019400k
 2020500k
   

 

This is how i want to display.