topic Re: Displaying Text in Text Box in Specific Order in QlikView

Displaying Text in Text Box in Specific Order

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

Hello everyone,

I'm working on report style app (mostly text based) that will take in a bunch of text and display it for users to read. The issue I'm struggling with is actually getting specific text displayed in particular order. I've attached sample of spreadsheet that reporter will use to copy his statements about specific commodities in different sectors.

I've also attached a QVW that has the text boxes displaying text from Message field as I would like them to, but I cannot think of an expression that would actually list the messages in correct order, one-by-one.

There will always be one Date selected and one Commodity selected, so the task is to display bulleted list of statements for segment 1 and 2 of selected commodity.

Does anyone know of an expression that would do that? Many thanks for any feedback or suggestions.

Mikhail Bespartochnyy

Re: Displaying Text in Text Box in Specific Order

swuehl — Tue, 07 Feb 2017 22:17:11 GMT

Something like

=Concat({<Commodity = {Wheat}, Segment= {'Segment 1'}>}DISTINCT Message,chr(10),[Point #])

or with selected commodity

=Concat({< Segment= {'Segment 1'}>}DISTINCT Message,chr(10),[Point #])

Re: Displaying Text in Text Box in Specific Order

sunny_talwar — Tue, 07 Feb 2017 22:17:57 GMT

May be Concat()

=Concat(DISTINCT {<Commodity = {Oil}, Segment = {'Segment 1'}>} Message, Chr(10), [Point #])

Re: Displaying Text in Text Box in Specific Order

mbespartochnyy — Tue, 07 Feb 2017 22:28:20 GMT

Thanks, Stefan! This is exactly what I was looking for.

Mikhail B.

Re: Displaying Text in Text Box in Specific Order

mbespartochnyy — Tue, 07 Feb 2017 22:31:22 GMT

Sunny, thanks for the answer too!