Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis syntax - nested functions

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

1 Solution

Accepted Solutions
Not applicable
Author

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)

View solution in original post

1 Reply
Not applicable
Author

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)