topic Suppress column values displayed on multiple rows? in QlikView

Suppress column values displayed on multiple rows?

Wed, 03 Apr 2013 12:58:22 GMT

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:

Would prefer this result:

Re: Suppress column values displayed on multiple rows?

kaushiknsolanki — Wed, 03 Apr 2013 13:02:27 GMT

Hi,

Convert your chart to Pivot Table.

Regards,

Kaushik Solanki

Re: Suppress column values displayed on multiple rows?

Wed, 03 Apr 2013 13:37:30 GMT

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?

Thank you