Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.