Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: 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