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

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
bijoylalu007
Partner - Contributor II
Partner - Contributor II
‎2017-01-08 07:59 AM

How to get Maximum of Sum of a measure with two dimension.

I want to show a line chart with one line as Highest and second as Average score of a set together with the actual score of selected dimension as third line.

Apart from the selected dimension we have two other dimension, on which we need to fetch data.(Main_Skill and Sub_Skill in the attached qvf)

i am getting correct value for Actual Score and Average score, but wrong data for highest.

Kindly advise.

TestMaxofSum.qvf
579 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2017-01-09 02:48 PM

What expression did you use for calculating highest score? I don't see any expression in the attached qvf. Did you try using Max(Score) ?

509 Views
0 Likes
sunny_talwar
MVP
MVP
‎2017-01-09 03:01 PM

What is your expected answer here?

509 Views
0 Likes