set analysis writing

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

i have a problem with set analysis syntax, this :

MaxString({<Année={2016},[Numéro de prospectus]={$(=subfield(concat( {<Année={2016}>}DISTINCT [Numéro de prospectus],';'),';',2))}>}[Libellé de prospectus])

doesn't work.

Do you have some idea ?

Thanks

Sophie

Re: set analysis writing

Miguel_Angel_Baeyens — Tue, 03 Jan 2017 16:42:40 GMT

What is the problem? You see no data? Is there any error in the object? Is it a text object or a table?

Two things I can think of without more background:

If you are expecting a string (not a number) then you need to use a single quote for the Numéro de prospectus field:

MaxString({<Année={2016},[Numéro de prospectus]={"$(=subfield(concat( {<Année={2016}>}DISTINCT [Numéro de prospectus],';'),';',2))"}>}[Libellé de prospectus])

Also, try the SubField() function separately and make sure it returns as expected, one single value

EDIT: Set to double quotes because of the use of single quotes already in the functions.

topic set analysis writing in QlikView

set analysis writing

Re: set analysis writing