Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thanks Stefan, That worked brilliantly.