topic Re: List with concat as modifier in QlikView

List with concat as modifier

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

Hi all

I am trying to produce a list of names with the following function:

concat({<Order_Channel_Name={"=sum({1<[Transaction_Date.autoCalendar.Year]={""$(vLY)""}, [Transaction_Date.autoCalendar.Month]={""$(vMonth)""}>}Value-Tax)>0"}>}distinct Order_Channel_Name, ',')

This actually works and returns a comma separated list of values (Order_channel_name)

Now I want to put these values in the following function:

sum({<Accumulator_Type={'RETAIL'},Order_Channel_Name={---Put above function here!!!}>}Value-Tax)

Apparently copying the first function and pasting it into the second doesn't work.

Any ideas?

Re: List with concat as modifier

Anil_Babu_Samineni — Wed, 21 Feb 2018 11:02:57 GMT

Perhaps this?

sum({<Accumulator_Type={'RETAIL'},Order_Channel_Name={$(=Chr(39) & concat({<Order_Channel_Name={"=sum({1<[Transaction_Date.autoCalendar.Year]={""$(vLY)""}, [Transaction_Date.autoCalendar.Month]={""$(vMonth)""}>}Value-Tax)>0"}>}distinct Order_Channel_Name, ',') & Chr(39))}>}Value-Tax)

Re: List with concat as modifier

Anonymous — Wed, 21 Feb 2018 11:25:10 GMT

I see what you are doing with Chr(39). But putting it in the beginning and the end is not enough, it needs to be around each word that is concatenated. I tried the separator to be 'Chr(39),Chr(39)' but it doesn't work. It just adds the actual string "Chr(39)" before and after the comma.

Any other ideas?

Re: List with concat as modifier

Anil_Babu_Samineni — Wed, 21 Feb 2018 11:30:47 GMT

My bad, Here it is?

None of them won't help, I may ask sample application

Re: List with concat as modifier

teempi — Wed, 21 Feb 2018 11:40:08 GMT

Hi,

Maybe like this:

sum( {<Accumulator_Type={'RETAIL'}, Order_Channel_Name={"=sum({1<[Transaction_Date.autoCalendar.Year]={""$(vLY)""}, [Transaction_Date.autoCalendar.Month]={""$(vMonth)""}>} Value-Tax) > 0"} >} Value-Tax)

-Teemu