topic Coloring bars in drill down dimension using Class function in QlikView

Coloring bars in drill down dimension using Class function

kaifi_nadeem — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Need to color bars of chart according to drill down (With calculated dimensions). Below are my requirement and attached is the screen shot of desired result.

Within 24 : Green

24-36 : Yellow

36-48 : Orange

>48 : Red

Expression for Dimensions:-

1) =IF(Round([TpT Act based on time diff]/60)<23,'0-20',dual(Replace(class(Round([TpT Act based on time diff]/60),4),'<= x < ','-'),class(Round([TpT Act based on time diff]/60),4)))

2) =dual(Replace(class(Round([TpT Act based on time diff]/60),.5),'<= x < ','-'),class(Round([TpT Act based on time diff]/60),.5))

Measure:-

count({1< Process={'Total Time*'}>} Process)+ Sum({1}0)

Re: Coloring bars in drill down dimension using Class function

Anil_Babu_Samineni — Fri, 16 Feb 2018 17:59:23 GMT

Can you provide sample application?

Re: Coloring bars in drill down dimension using Class function

ychaitanya — Fri, 16 Feb 2018 22:16:44 GMT

use the Background Color option for the Expression and use the respective RGB's for the categories.

Re: Coloring bars in drill down dimension using Class function

kaifi_nadeem — Sat, 17 Feb 2018 06:05:20 GMT

Hi Anil,

Attached is the test application.

Thanks