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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
johngouws
Partner - Specialist
Partner - Specialist

Calculating daily float variance.

Good Day.

I am hoping someone can assist with a way of obtaing a "Float Variance". This is the difference between today's Opening Float less yesterday's Closing Float. The attached qvw has a simple Fact table as well a a Daily1 table which is where I have tried using the expression "sum(opening_float - previous(closing_float)" to create the Float Variance value.

In the Fact1 chart I am using the expression "sum(opening_float - above([Closing Float])" to prove my variance, but in the solution this cannot work because when I select business day 2374, the variance disappears.

Ideally I need to select a day, 2347, and it should return the opening, closing and variance values for the day. The final solution will have a dash with a textbox showing the values.

I appreciate your assistance. Thank you in advance - John

1 Solution

Accepted Solutions
johngouws
Partner - Specialist
Partner - Specialist
Author

Hi All.

No worries. I found where I was going wrong and my problem is resolved.

John

View solution in original post

1 Reply
johngouws
Partner - Specialist
Partner - Specialist
Author

Hi All.

No worries. I found where I was going wrong and my problem is resolved.

John