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: 
ngovula
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
   
5 Replies
Kushal_Chawda

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

ngovula
Contributor
Contributor
Author

Yes, we used it in pivot table.
Kushal_Chawda

would you be able to share sample?

ngovula
Contributor
Contributor
Author

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

 

This is how i want to display.

Babu_3103
Contributor III
Contributor III

i am Also Having same concern