Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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'

dwivedi_shashan
Contributor II
Contributor II
Author