Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
haymarketpaul
Contributor III

Colouring part of a pivot table expression

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)

5 Replies
Not applicable

Re: Colouring part of a pivot table expression

Why not to use 2 columns?

1'st: Sum(RowsRead)

2'nd: Sum(RowsWithErrors)


???

haymarketpaul
Contributor III

Re: Colouring part of a pivot table expression

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

Not applicable

Re: Colouring part of a pivot table expression

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

haymarketpaul
Contributor III

Re: Re: Colouring part of a pivot table expression

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...

PivotChart.gif

thornofcrowns
Valued Contributor II

Re: Colouring part of a pivot table expression

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

Community Browser