Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

how to show particular values by red dots in line chart ??

Hey,

I have a line chart. In that i want the values that goes above 102 and below 98 should be shown by red dot. How can i do that??

Please tell em the expression.

My expressionj is :  Sum(Price)/Count(Price)

Thanks

12 Replies
DavidFoster1
Specialist
Specialist

Use the expression formatting (the plus button on the expression in the expression list). Use simple IF logic to control the background colour of the expression

nikhilgarg
Specialist II
Specialist II
Author

HEy,

Thanks for hint. But actually want i want is :

I want values vhich is shown by dots to be colored only . Here whole line is colored .

How can i make the corners only colored and not whole line ??

Thanks

senpradip007
Specialist III
Specialist III

Can you upload sample qvw?

Not applicable

Please upload the QVW file

nikhilgarg
Specialist II
Specialist II
Author

Please see attached file...

I want only values to be changed in color and not whole lione.

Thanks

nikhilgarg
Specialist II
Specialist II
Author

Please see attached file...

I want only values to be changed in color and not whole lione.

Thanks

sivarajs
Specialist II
Specialist II

Write a condition like below as david suggested,

Expression column is A=Sum(Price)/Count(Price)

if(A>=98 and A<=108, lightred())

senpradip007
Specialist III
Specialist III

PFA. Hope it will help.

nikhilgarg
Specialist II
Specialist II
Author

HEy,

I am using personal edition. So cannot open your qvw. Please tell me here what to do.

Thanks