Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Need to display data in a text object with background color changing according to given set of conditions

Hi ,

I need to display a data in Text object based on the value of the background color of the text object should change and in the text object I need to  display the sum of Sales(Actual) for a given product in the text object with appropriate background color

If the value of the Sum(ActualSales)/Sum(PlannedSales) for a given product is less than 60% the background should be in Red color
If the value of the Sum(ActualSales)/Sum(PlannedSales) for a given product is greater than 85% the background should be in Green color
If the value of the Sum(ActualSales)/Sum(PlannedSales) for a given product is between than 60% & 85 % the background should be in Yellow color.

I have attached the Sample Data for the same.

Any help in this regard is appreciated

Thanks in Advance

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

Re: Need to display data in a text object with background color changing according to given set of conditions

Dear,

Kindly find the attachment.

Thanks,

Mukram.

View solution in original post

4 Replies
Highlighted
Specialist II
Specialist II

Re: Need to display data in a text object with background color changing according to given set of conditions

PFA

Highlighted
MVP
MVP

Re: Need to display data in a text object with background color changing according to given set of conditions

May be like attached sample

Highlighted
Specialist III
Specialist III

Re: Need to display data in a text object with background color changing according to given set of conditions

Dear,

Kindly find the attachment.

Thanks,

Mukram.

View solution in original post

Highlighted
Not applicable

Re: Need to display data in a text object with background color changing according to given set of conditions

Thanks Nizam,tresesco,Mukram for your timely help.

All the three worked..:)