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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Suppress column values displayed on multiple rows?

Hello,

I have salesperson on multiple rows and would like to clean it up so the value of Salesperson is distinct. 

Any suggestions?

Also, what is a great reference for writing QlikView expressions?

Thanks

Example:

Capture.PNG

Would prefer this result:

Capturez.PNG

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Convert your chart to Pivot Table.

Regards,

Kaushik Solanki    

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Kaushik,

That does work...  but I lose the subtotals on GL Credit / Debit Sales, Net Sales, and Percentages on the SalesPerson and the grand totals on the table. Do you have to manually calculate those in the Pivot?

Capturex.PNG

Thank you