Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the Set the Values Default in Line Chart with Original data Point?

Hi All,

I have a Chart like below.

Screenshot_3.png

From the Above Chart, i need to Bring the value which is more than 2 to 2. But the actual value should be shown as a data point.Like below Screen Shot

Screenshot_4.png

I got the above chart But when I try to convert this to Percentage(%). I am getting the data point as 200 % default. It is not showing the actual value

Screenshot_5.png

I Need to bring the Value Which is greater than 200% to 200%. by Showing its original value as a data Point

Please find the below attached qvw and Excel data for your reference

I need it in Expression, not in Script and also i need the out in %  like above Screen Shot with Original data Points

Kindly Help me Out of this

Thanks,

Muthu

12 Replies
sunny_talwar

What is the expected output here? What is wrong?

Not applicable
Author

Please find the below Attachment and kindly Look in to Third Sheet

Thanks,

Muthu

sunny_talwar

I am unable to find a way to make this work.... may be you need to use overlapping charts? Not sure...