topic Combine Measures in App Development https://community.qlik.com/t5/App-Development/Combine-Measures/m-p/1151578#M20663 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am attempting to create a measure for test values based off the percentiles in the database. I am currently using the expression FirstSortedValue(Distinct Value, AssessmentDate) to pull in the initial test date. I am struggling though to write an expression where I can have Percentile based off the initial date above. I wanted to know if there is a way to combine the 2 in&nbsp; a bar chart so the bar represents the percentile but when you hover it displays the initial date/value. Let me know if I can explain anything better.&nbsp; The initial and latest measures are&nbsp; based on the first sorted value expression above. I need the bar to be based on a field Percentile but for those measures. </P><P><IMG alt="Screen Shot 2016-07-26 at 3.28.11 PM.png" class="jive-image image-1" src="/legacyfs/online/132588_Screen Shot 2016-07-26 at 3.28.11 PM.png" style="height: 390px; width: 620px;" /></P><P></P><P>Thanks,</P><P>Philip Radovich</P></BODY></HTML> Tue, 26 Jul 2016 19:34:21 GMT philip_radovich 2016-07-26T19:34:21Z Combine Measures https://community.qlik.com/t5/App-Development/Combine-Measures/m-p/1151578#M20663 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am attempting to create a measure for test values based off the percentiles in the database. I am currently using the expression FirstSortedValue(Distinct Value, AssessmentDate) to pull in the initial test date. I am struggling though to write an expression where I can have Percentile based off the initial date above. I wanted to know if there is a way to combine the 2 in&nbsp; a bar chart so the bar represents the percentile but when you hover it displays the initial date/value. Let me know if I can explain anything better.&nbsp; The initial and latest measures are&nbsp; based on the first sorted value expression above. I need the bar to be based on a field Percentile but for those measures. </P><P><IMG alt="Screen Shot 2016-07-26 at 3.28.11 PM.png" class="jive-image image-1" src="/legacyfs/online/132588_Screen Shot 2016-07-26 at 3.28.11 PM.png" style="height: 390px; width: 620px;" /></P><P></P><P>Thanks,</P><P>Philip Radovich</P></BODY></HTML> Tue, 26 Jul 2016 19:34:21 GMT https://community.qlik.com/t5/App-Development/Combine-Measures/m-p/1151578#M20663 philip_radovich 2016-07-26T19:34:21Z