topic Conditional coloring of line in a mini chart of a staight table in QlikView

Conditional coloring of line in a mini chart of a staight table

Anonymous — Mon, 22 Jan 2018 11:53:07 GMT

How can a line be transparent or White color in a mini chart if all the data over a period are not changing.

For example Ben score keep changing so I want to the see mini chart for him, but John doe snot change so I do not want to see the mini chart for him at all.

I tried to color the line in white if all data were the same so =if(Count(DISTINCT(Score))=1,white(),black()), but it seemed to be ignored.

Any idea?

Many thanks,

Raphael

Re: Conditional coloring of line in a mini chart of a staight table

Anil_Babu_Samineni — Mon, 22 Jan 2018 13:45:24 GMT

May be use this?

Re: Conditional coloring of line in a mini chart of a staight table

Anonymous — Mon, 22 Jan 2018 13:48:52 GMT

that gave me the above, thanks, but not what I am after - I do not want to see anything for John as John's score is not changing over time - I want to see only a chart for Ben as Ben Score changes over time.

Re: Conditional coloring of line in a mini chart of a staight table

Anil_Babu_Samineni — Mon, 22 Jan 2018 13:56:44 GMT

The appearance Dynamic option not there? So, Either you could use 2 charts to build like your achievement

Re: Conditional coloring of line in a mini chart of a staight table

niclaz79 — Mon, 22 Jan 2018 14:32:19 GMT

Hi Raphael,

I believe it would be easier to not output anything when count(distinct(Score) = 1.

So change your expression to:

if(Count(Distinct Score) <= 1, null(),Sum(Score))

Re: Conditional coloring of line in a mini chart of a staight table

Anonymous — Mon, 22 Jan 2018 14:47:14 GMT

thanks, that make sense, but does not work for me, does it work for you? for me it just does not show anything for both Ben and John.