topic Re: Colour on Pivot table in App Development

Colour on Pivot table

Frédéricdh — Thu, 06 Jun 2024 12:53:03 GMT

I made a pivot table with data from a SQL request:

This is the result:

And then I want to color the background of the Dimension ORT with diverse Color, but Qlik don't do it. It colors only the value 'sonstige Ort' and not the others. WHY?

Can anyone help me.

thanks a lot and in advance.

Best Regards

Frédéric

Re: Colour on Pivot table

Brian_C — Thu, 06 Jun 2024 13:13:17 GMT

In the background color expression property under the dimension you can put an expression such as

if(match(RowNo(),'1','3'),red(),green()) and this will set alternate rows to different colours.

I hope this helps you.

Brian

Re: Colour on Pivot table

Frédéricdh — Fri, 07 Jun 2024 07:50:15 GMT

No it is not, what Im looking for.

But thx for the help

Frédéric

Re: Colour on Pivot table

Brian_C — Fri, 07 Jun 2024 08:10:03 GMT

OK Can you explain a little more what your requirement is.

Re: Colour on Pivot table

Frédéricdh — Fri, 07 Jun 2024 08:13:20 GMT

can we meet online? With a visio coference?

Re: Colour on Pivot table

Frédéricdh — Fri, 07 Jun 2024 08:19:34 GMT

I come back to you, when I have a visio prog.

thanks for the help

Re: Colour on Pivot table

Frédéricdh — Mon, 10 Jun 2024 09:34:59 GMT

Hello Brian,

i don'r understand.

I have two pivot table.

One with this Function:

= if ( JW < (Year(addmonths(Today(1),-1) ) *100 + Week(addmonths(Today(1),-1))) + 1, '<= ' & (Year(addmonths(Today(1),-1,0) ) *100 + Week(addmonths(Today(1),-1,0))), If( JW <= (Year(addmonths(Today(1),1,0))*100 + Week(addmonths(Today(1),1,0))),JW))

And the background of the dimension is not properly colored

And the second with this Function:

= if (JW <= (Year(Today(1))*100 + Week(Today(1))), '<=' & (Year(Today(1))*100 + Week(Today(1))) )

and the background of th dimension is properly colored. Like I need

Re: Colour on Pivot table

Frédéricdh — Mon, 10 Jun 2024 12:01:02 GMT

I found the problem, it was in Presentation: Suppress Zero-Values. and now the background is colored. I don't understand why