topic Re: Writing a narrative using values from a field in QlikView

Writing a narrative using values from a field

helen_pip — Tue, 18 Jun 2019 13:30:07 GMT

Dear Qlikview user

I was wondering if someone could kindly help me. I am trying to write a narrative around the values in a field

The field will contain 3 rows

Surgeon consenting

Anaesthetist not allocated

List alterations

In a text object I would like to use all 3 values from the field in a narrative/summary I.e.

Today there were 3 sessions and the sessions were delayed to the Surgeon Consenting and an in another session the Anaesthetist not allocated and there were also List alterations

I have tried various methods I.e. Concat, MaxString, If(GetSelectedCount(

but cannot seem to find a suitable solution. At the present time I am just looking for proof of concept that I can achieve this and will work on my data structuring for the longer term

Any help or advice would be great;y appreciated

Kind Regards

Helen

Re: Writing a narrative using values from a field

Brett_Bleess — Wed, 17 Jul 2019 19:28:03 GMT

Best I have is link to the Design Blog space on Community for ideas there, the only other thing would be to have a look at the demo site maybe to see if something there may help as well.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

https://demos.qlik.com/qlikview

Hope this helps, sorry I do not have something better for you.

Regards,
Brett

Re: Writing a narrative using values from a field

qliksus — Thu, 18 Jul 2019 06:00:24 GMT

Assuming you have a table like the below

load * inline [

Field , order

Surgeon consenting ,1

Anaesthetist not allocated ,2

List alterations ,3 ] ;

You can fit the narrative using the below expression

=' Today there were 3 sessions and the sessions were delayed to the' & firstsortedvalue(Field ,order,1) & 'and an in another session the ' & firstsortedvalue(Field ,order,2) & ' and there were also ' firstsortedvalue(Field ,order,3)

Here the Exp1 = maxstring(Field,1)