topic Re: Using concat in a set expression to seperate selections from a list in QlikView

Using concat in a set expression to seperate selections from a list

tinkerz1 — Fri, 16 Oct 2015 09:08:50 GMT

Hi,

I am trying to set up a series of tables, each table is based on a function that is in a list.

So the first selection in the field list selection will be table 1

and the second selection in the list is table 2, etc

I can see concat work when I set it up as a caption, but when I put it in an expression formula it wont work.

How can I get this to work is concat correctly used?

Thanks,

count(distinct{<[Business Function]={'=subfield(concat(distinct [Issue - Business Function],','),',',1)'},[Status]=p([Dependency Analysis]::[Issue - Status])>}[Issue - ID])

Re: Using concat in a set expression to seperate selections from a list

Anonymous — Fri, 16 Oct 2015 09:25:04 GMT

What is the Content of Business Function?

If it is like

Support

Marketing

Sales

etc.

your concat will result in "Support, Sales" etc. So there will no hit

When you select only 1 Business Function it should work, can you confirm?

Re: Using concat in a set expression to seperate selections from a list

tinkerz1 — Fri, 16 Oct 2015 09:32:03 GMT

Yes its just a list of business area's

As I wrap the concat function within a subfield and use an index of 1, that will pass the first item in the list back.

So in your list it will be support.

It wont work when i select only one, but the caption works:

subfield(concat(distinct [Business Function],','),',',1)

so why wont this work in the set analysis?

Re: Using concat in a set expression to seperate selections from a list

tinkerz1 — Fri, 16 Oct 2015 09:42:18 GMT

this works, but I dont understand why the '' is used to qualify the dollar expansion?

{'$(=subfield(concat(distinct [Issue - Business Function],','),',',1))'}

Re: Using concat in a set expression to seperate selections from a list

tresB — Fri, 16 Oct 2015 09:48:23 GMT

'' would not be required unless there is a space between your resultant string, i.e. if your first [Business Function] is like 'XXXXYYY' and not like 'XXX YY'.