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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
socura
Contributor
Contributor

max value of subfields

Hi,

I would like to get the max value of all subfieds of a concat field like

concatfield: 10, 50, 700, 100, 300

concatmax: 700

Is it possible?

Thanks

Mario

 

3 Replies
Brett_Bleess
Former Employee
Former Employee

Try having a look at the following link, hopefully this will help you sort things out:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
marcus_sommer

It's not possible within the UI unless you would try to apply various string-functions within multiple nested if-loops. Even with just those few values from your example it would need quite a lot of efforts.

Much better would be to split these concat-string within the load per subfield() maybe within an extra table which just contains the concat-string as KEY and the splitted values from them. Then just a max(SplittedValues) would be enough.

- Marcus

jensmunnichs
Creator III
Creator III

If you're trying to do this in front end, you can use =RangeMax($(=concatfield))  in a text object (for example) to find the max. Even if that's the case, however, I suggest you follow @marcus_sommer 's advice and do it in back end instead.