Color the max values corresponding to a dimension in a table.

Anonymous — Thu, 28 Jun 2018 06:23:41 GMT

Hi Experts,

I am trying to solve a business problem where I have to color the maximum switching loss for drugs. Below is the sample data along with the result I want. I need help in creating a color expression in QlikSense to apply this logic.

Prev Drug	Curre Drug	Month	Patient count
A	B	Jan	29
A	C	Feb	60
A	B	Feb	40
B	B	Feb	45
B	C	Mar	60
B	C	Mar	65
B	D	Apr	44
D	D	May	20
D	E	Jun	15
D	F	Jul	55

Prev Drug	Curr Drug	Sum(Patient Count)
A	B	69
A	C	60
B	B	45
B	C	125
B	D	44
D	D	20
D	E	15
D	F	55

Thanks in Advance.

Re: Color the max values corresponding to a dimension in a table.

jonathandienst — Thu, 28 Jun 2018 06:29:49 GMT

Something like

If(Rank(Sum([Patient Count])) <=3, Red())

topic Re: Color the max values corresponding to a dimension in a table. in QlikView

Color the max values corresponding to a dimension in a table.

Re: Color the max values corresponding to a dimension in a table.