topic Re: Colouring part of a pivot table expression in QlikView

Colouring part of a pivot table expression

haymarketpaul — Fri, 23 May 2014 13:31:18 GMT

I have the following expression in a pivot table chart

If(Sum(RowsWithErrors)=0,Sum(RowsRead),Sum(RowsRead) & ' (' & Sum(RowsWithErrors) & ')')

I would like if possible to colour the part in bold so it shows as red in the pivot table

Any ideas?

Message was edited by: Paul Nockolds - I've added the qvw in case anyone has any great ideas (see sheet 2)

Re: Colouring part of a pivot table expression

Fri, 23 May 2014 13:38:42 GMT

Why not to use 2 columns?

1'st: Sum(RowsRead)

2'nd: Sum(RowsWithErrors)

???

Re: Colouring part of a pivot table expression

haymarketpaul — Fri, 23 May 2014 13:42:12 GMT

Yes i could do and in fact have the RowsWithErrors expression disabled as a separate column right now but each day will add a new column as there's a new file every day, so it will grow and grow over time so i thought having only one column might be easier

Re: Colouring part of a pivot table expression

Fri, 23 May 2014 13:47:44 GMT

But you will be able to do partial sums etc....

Or maybe better to use some visual chart. For exmaple in Bar Chart you hav "HasErrorBars" option.

regards

Darek

Re: Re: Colouring part of a pivot table expression

haymarketpaul — Fri, 23 May 2014 13:53:36 GMT

Currently it looks like this and each day will add a new column. I just thought being able to highlight the bracketed number (if any) would help to highlight files that have error rows in them...

Re: Colouring part of a pivot table expression

ThornOfCrowns — Fri, 23 May 2014 13:59:01 GMT

I don't think you can change just part of a cell, it seems to be an "all or nothing" deal.