topic Re: Concat inside another concat in QlikView

Concat inside another concat

jduluc12 — Fri, 14 Apr 2017 15:40:14 GMT

Hi,

I have a data set like this

cust date amount

cust1 01/01/2017 100

cust2 02/05/2017 200

cust3 03/04/2017 300

I need to print the name of cust in a text box which does not have any amount within a certain time period

here is what i am trying

=concat({1}if(not match(cust,

concat({1}total if( aggr(sum({<date={">='01/12/2017'<='02/06/2017'"}>}Amount, cust)>0, chr(39)&cust & chr(39) &chr(44)))),

cust) & chr(10))

This gives me all customers instead of giving cust1 and cust3.

when i try this

concat({1}total if( aggr(sum({<date={">='01/12/2017'<='02/06/2017'"}>}Amount, cust)>0, chr(39)&cust & chr(39) &chr(44)))) seprately then

it gives me the right values which is cust2

somehow when i put this expression in another concat then it return null values.

can anyone help please?

Thanks.

swuehl — Fri, 14 Apr 2017 15:54:18 GMT

Maybe try a set expression like

=Concat({<cust = e({<amount = {"*"}, date={">='01/12/2017'<='02/06/2017'"} >} cust) >} DISTINCT cust)

jduluc12 — Fri, 14 Apr 2017 16:21:25 GMT

Hi Stefan

When i replace e() with p() then i get cust2 but when i use e() then i do not get expected value cust1, cust3.

swuehl — Fri, 14 Apr 2017 16:25:48 GMT

Are there any current selections?

=Concat({1<cust = e({<amount = {"*"}, date={">='01/12/2017'<='02/06/2017'"} >} cust) >} DISTINCT cust)

jduluc12 — Fri, 14 Apr 2017 16:31:23 GMT

I was using 1 with e so it was not working.

Now it works.