formatting in

[schumi1980]

Dear All

I am exporting the following table (pivot table) from Qlikview with a Macro:

However, I would like to change the colour/boldness of each total line to something like

Is there a way to make the macro choose each row that contains the word total (I do not know how to do that) and then would format all those rows?

Or is there a way to format already in qlikview the table accordingly?

Many thanks for your help.

Best regards,

Jan

[marcus_sommer · Accepted solution]

You could format it in QlikView with attribute-expressions within the dimensions/expressions - just click on the small + sign by them and enter there something like: if(dimensionality()=1, yellow()). Also possible is to use the custom cell-format - just a right click on the object and choosing the custom formatting.

Another way would be to use a custom formatting within the excel - it won't directly work with the export-feature because you would need to apply the formatting afterwards (unless you manipulate your global excel-template) but if you opened a prepeared excel-file and copy & paste the table there the formatting would be applied.

- Marcus

[vishsaggi]

You can do this in qlikview using custom format cell. Like click Ctrl+G on your key board and right click on your pivot table where ever you have this total or that total row right click on it then select Custom Format Cell then change the background color and see it that works.

[schumi1980]

Many thanks.

The dimensionality()=1 was key for a lot of cool stuff.

Jan

[schumi1980]

In the end I resorted to that. Many thanks.

Jan