Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted
Not applicable

Re: Set Analysis syntax - nested functions

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
Highlighted
Not applicable

Re: Set Analysis syntax - nested functions

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