topic Re: Logic Help in QlikView

Logic Help

abhaysingh — Mon, 16 Nov 2015 12:56:16 GMT

Hi all,

I have to show day wise resolution time, in table,, but i a day resolution time can be so many so i have to put resolution time which took maximum time.

i have one calculative field called resolution time i.e. Datecreated- Dateresolved = ResolutionTime

I m trying to put Dimension as Day and measure as max(ResolutionTime)

but getting error..

also tried by max(frac(ResolutionTime))

can any one pls suggest in it..

Thanks

Re: Logic Help

sunny_talwar — Mon, 16 Nov 2015 13:00:07 GMT

What is the exact error you are seeing?

Re: Logic Help

tresB — Mon, 16 Nov 2015 13:01:24 GMT

Have you checked if ResolutionTime has got numeric values or string or '-'?

Re: Logic Help

Mark_Little — Mon, 16 Nov 2015 13:12:53 GMT

Hi,

As Sunny has asked, knowing the error would help advise.

Also as Tresesco has asked have you checked the values you are receiving?

On the back of there comment i would advise making a table with the ID field, Datecreated, Dateresolved and ResolutionTime on and check the results.

Also where you calculating the ResolutionTime in script or front end?

Mark

Re: Logic Help

Anonymous — Mon, 16 Nov 2015 13:13:11 GMT

Does your Day as dimension associated with ResolutionTime which you have created from

Datecreated- Dateresolved

Re: Logic Help

Mon, 16 Nov 2015 16:18:40 GMT

Try Rangemax(ResolutionTime) as your expression. If that works, then the data for ResolutionTime contains strings