topic Re: Concat dinamics string in App Development

Concat dinamics string

Max75 — Fri, 26 Jan 2024 17:17:39 GMT

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

Re: Concat dinamics string

maxgro — Fri, 26 Jan 2024 17:43:30 GMT

Maybe with the below() function

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

Re: Concat dinamics string

MatheusC — Fri, 26 Jan 2024 18:05:41 GMT

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

Re: Concat dinamics string

MatheusC — Tue, 30 Jan 2024 12:45:05 GMT

@Max75
Did you get the solution?

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

Thank you!

Re: Concat dinamics string

Max75 — Tue, 30 Jan 2024 12:52:43 GMT

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.

Re: Concat dinamics string

barnabyd — Tue, 30 Jan 2024 21:00:42 GMT

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.

Re: Concat dinamics string

Max75 — Wed, 31 Jan 2024 07:06:37 GMT

thx