topic Thanks. It helped. in QlikView

Calculations of field with different format

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

Hi,

I am new to qlikview and not able to get the correct result due to different formats of field when dividing Actual/Expected.

Below is field definition:

interval(Interval((End_Time-Start_Time),'ss')/5,'ss') as 'Expected'

COUNT(DISTINCT(updated)) as 'Actual'

For ex: My Expected is 516 and actual is 29 but actual/expected is coming 4855.8139534884.

Please help.

dwivedi_shashan — Tue, 16 Jul 2019 09:51:53 GMT

Hi,

Is there someone who have faced same issue and help on this

Frank_Hartmann — Tue, 16 Jul 2019 10:40:15 GMT

num#(interval(Interval((End_Time-Start_Time),'ss')/5,'ss')) as 'Expected'

dwivedi_shashan — Tue, 16 Jul 2019 17:51:50 GMT