topic using the visual cues in QlikView

using the visual cues

zturaiki — Mon, 05 Aug 2013 08:02:05 GMT

I have this Table

Doctor Code	Prescriptions 2013 June	Prescriptions 2013 July
A	936	936
B	849	740
C	676	612
D	576	575
E	567	290
F	548	484

Total No. of Prescription for June and July for each doctor

i need to make a comparasion between these tow month,.,.. if the total No. ot prescription of Dr.A in June is Geater than Total No. of Prescription in July

this value in the font for the value will be green ... and if not,,, it will be red ...

as u can see in the picture :

Re: using the visual cues

Mon, 05 Aug 2013 08:10:32 GMT

in text colour--

write if(precription2013july<precription2013june,red(),green())

Re: using the visual cues

ariel_klien — Mon, 05 Aug 2013 08:49:51 GMT

Try to put this in the expression > text color

if(sum({<DoctorCode=>} Prescriptions2013June)=sum({<DoctorCode=>}Prescriptions2013July),Green(),Red())