This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
num#(interval(Interval((End_Time-Start_Time),'ss')/5,'ss')) as 'Expected'
View solution in original post
Is there someone who have faced same issue and help on this