topic Re: Text Object Expression that is agnostic to a specific selection in QlikView

Text Object Expression that is agnostic to a specific selection

Thu, 03 Dec 2015 20:28:09 GMT

Hi Qlik experts,

Below is a screenshot with several text objects, each with specific expressions. As shown in the 1st screenshot, these are all calculating as expected. However, I have a specific use case where I need to alter the way the Actual Cost to Date is calculating. I need to allow our users to select a Week End date value. As currently constructed, when I select say 11/27/15, my Actual Cost to Date calculates for that given week (which is correct). BUT, for this particular sheet, I need this object to be agnostic to the Week End selection and rather, calculate the Actual Cost to Date for the full project duration [Project Start Date through Project End Date]. How can i modify the below expression to accomodate this? Note: I have included a 2nd snapshot at the bottom to show what occurs when i do select 11/27/15. I need to select on the below list boxes, but have the Actual Cost to Date render the value in the 1st screenshot.

=num($(=$(vActualRev)),'$###,###,##0.##')

Re: Text Object Expression that is agnostic to a specific selection

sunny_talwar — Thu, 03 Dec 2015 21:00:06 GMT

I think seeing what you want is very useful, but not having information about what you have (we don't even know how your expression looks like because its hidden behind the variable) would be equally helpful. Would you be able to share a sample (may be with dummy data) and your expectation from the dummy data?

Re: Text Object Expression that is agnostic to a specific selection

Thu, 03 Dec 2015 21:24:42 GMT

I tried this (which includes showing the full expression and not the variable). I think this will work in that it will not respect the Week End selection which is what I want for this one object. Agree?

=num(sum({$<[Week End]=>}([Billable Hrs] * [Billing Rate])),'$###,###,##0.##')

Re: Text Object Expression that is agnostic to a specific selection

Wed, 09 Dec 2015 14:48:10 GMT

Hi - I needed to expand my original example and have since constructed the below expression within a text object.

Any suggestions would be much appreciated.

I need the math to do:

=10,000 - (10 * 100) + 9500))

=10,000 - 10,500

= - 500

But right now i have it incorrect as the math is doing:

= 10,000 - 1000 + 9500

= 18,500

=num(sum({$<[Week End]=>}[Original Rev Est]) - sum({$<[Week End]=>} ([Billable Hrs] * [Billing Rate])) + sum({$<[Week End]=>}([Estimate Cost to Complete])), '$###,###.00')