Concat dinamics string

[Max75]

Hello everyone

I would have a need to create a dynamic dimension that will couple existing strings to me.

The table is sorted by Number and event_id, and I would expect the data as in the result column

For each event_id I would expect the Result column to report the status of the string + the status of the next column.

Number	event_id	Status				Result
7001044391	3416040	DRAFT				DRAFTIPT
7001044391	3450610	IPT				IPTIPF
7001044391	3450663	IPF				IPFIPT
7001044391	3551672	IPT				IPTIPF
7001044391	3551700	IPF				IPFIPD
7001044391	3551941	IPD				IPDIPT
7001044391	3578817	IPT				IPTIPF
7001044391	3578842	IPF				IPFAPP
7001044391	3579753	APP				APPTBP
7001044391	3785133	TBP				TBPSIG
7001044391	3793140	SIG				SIG

[maxgro · Accepted solution]

Maybe with the below() function

https://community.qlik.com/t5/App-Development/Concat-dinamics-string/td-p/2411504

[MatheusC]

There is also a way to do this via script with
example of the peek function sorting with Order by desc

peek('campo',-1)

Regarts,
Matheus

[MatheusC]

@Max75 
Did you get the solution?

Close the topic with the solution met and leave a like if you found it useful.

Thank you!

[Max75]

Hi Mark

I certainly wasn't very clear. My request was referring to a set analysis and not in script.
Below might work, but it creates an unfilterable measure, whereas I should be able to filter for a given parameter.

[barnabyd]

G'day @Max75,

Both solutions provided above by @maxgro and @MatheusC will give you the output column you need but if you want it to be a filter then it must be a dimension in the table. Therefore, it's best to pre-calculate the column in the load script as in @MatheusC's solution.

Cheers, Barnaby.

[Max75]

thx