Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
dwivedi_shashan
Contributor II
Contributor II

Calculations of field with different format

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.

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

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

View solution in original post

3 Replies
dwivedi_shashan
Contributor II
Contributor II
Author

Hi,

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

 

Frank_Hartmann
Master II
Master II

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

View solution in original post

dwivedi_shashan
Contributor II
Contributor II
Author