Text Box Variable Date

Wed, 04 Jan 2012 15:25:07 GMT

Hi,

I have created a text box, and in that text box I want to enter the following text. 'The Report shows that the most amount of calls raised to FST was for Requests.'

However the word Requests may change over time dependant on the amount of calls logged (Some months it may be Fault calls, other months it may be Requests etc)

In Excel and Qlikview the information shows as below.

Type of Call	No of Calls	Average Time	Highest Time	Lowest Time
Fault	21	0:17:21	1:45:15	0:00:43
Request	66	6:49:42	79:53:42	0:01:19

As you can see I am looking for Qlikview to look at the 'No of Calls' section and whichever is higher, ask it to choose the Type of Call and put it where Requests would be in the above sentance.

Regards,

Jon Ditchfield

PS: I am a novice at Qlikview and although I have the Personal Edition of Qlikview, I have used up all my conversion licences so will not be able to view any Qlikview file that are not my own.

Text Box Variable Date

swuehl — Wed, 04 Jan 2012 15:33:11 GMT

Try:

='The Report shows that the most amount of calls raised to FST was for ' & FirstSortedValue( [Type of Call], -[No of Calls] ) &'.')

And have fun,

Stefan

Text Box Variable Date

Wed, 04 Jan 2012 15:41:47 GMT

Thanks Stefan, That worked brilliantly.

topic Text Box Variable Date in QlikView

Text Box Variable Date

Text Box Variable Date

Text Box Variable Date