Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Re: Re: Colormix on Pivot table (multiple expressions)

Hi Jagan!

Thank you for this.

Let me try it and revert...

Highlighted
Not applicable

Re: Re: Colormix on Pivot table (multiple expressions)

Thanks Jagan.

I think I just need to amend this slightly so three colours can be produced (red, amber, green).

Thank you.

Highlighted
Not applicable

Re: Re: Colormix on Pivot table (multiple expressions)

Thanks Jagan.

I think I just need to amend this slightly so three colours can be produced (red, amber, green).

Thank you.

Highlighted
Contributor III
Contributor III

Re: Colormix on Pivot table (multiple expressions)

Hi Jagan,

Is there any way of not fixing the color of the first row?

You used this expression:

=If(RowNo() = 1, RGB(255, 0, 0)

If([Sales] <= vAvgYearlySales, RGB(1* ([Sales]/1000), 0,0), RGB(0, 1* ([Sales]/1000), 0)))

If I delette the bold section, hopping to free the color of the first row  QV pop up an error about exceeding the asigned memory...

Highlighted
MVP & Luminary
MVP & Luminary

Re: Colormix on Pivot table (multiple expressions)

Hi,

Try like this

=If(RowNo() = 1, RGB(255, 255, 255),

If([Sales] <= vAvgYearlySales, RGB(1* ([Sales]/1000), 0,0), RGB(0, 1* ([Sales]/1000), 0)))

RGB(255, 255, 255) - White the default color


Regards,

Jagan.