Set Analysis syntax - nested functions

Wed, 25 Nov 2020 16:16:04 GMT

Hi folks,

I have an expression that looks like this

=subfield(concat(DISTINCT{MLState<Date = {"$(='>=' & Min([Cal Date]) & '<=' & Max([Cal Date]))"}>}Date, ';', Date), ';', varEvrank)

It returns a single Date based on the users selection of varEvrank and [Cal Date]. It works perfectly if I paste this expression into a text box.

I'm trying to insert this subfield into another set analysis expression, so that I get a text box with all the relevant information for that Date.

=concat({MLState<Date = {'INSERT SUBFIELD RESULT HERE'}>}ML.machname & ': ' & Details,';',Date)

No matter what I do the syntax is incorrect. I've tried so many different ways that I'm beginning to get very frustrated.

Can anyone help?

Thanks in advance

Karen

Re: Set Analysis syntax - nested functions

Thu, 22 Jun 2017 12:00:05 GMT

Never mind! I've done it. At LAST. $(=subfield.....etc)

=concat({MLState<Date = {$(=subfield(concat(DISTINCT{MLState<Date = {"$(='>=' & Min([Cal Date]) & '<=' & Max([Cal Date]))"}>}Date, ';', Date), ';', varEvrank))}>}ML.machname & ': ' & Details,';',Date)

topic Set Analysis syntax - nested functions in QlikView

Set Analysis syntax - nested functions

Re: Set Analysis syntax - nested functions