Issue - Subtracting sets using Set Analysis

[#1]

Hi Qlikers,

I'm trying to create a dashboard to do a comparison based on dates. Specifically, current date against which ever date chosen on the slider.

The idea is to view new sets of data (on current date), data that has changed phase (on current date compare to date on slider) , data that has been cancelled (on current date compare to date on slider).
My solution for this is to use set analysis. I've created a dummy data sets just to try this out. (Refer attachment Funnel_Management_ChangeTab_Test2.qvw.) It works on this one.
But when I try it out on the actual data, does not seem to work. (Refer attachment Funnel_Management_ChangeTab_Test3.qvw).

Hope you guys could help me out here.

[arniewolff]

I believe the totals for the separate datasets are misleading. Since you may have some values that have dropped from the set and some values added, the difference (those that are in the current set and not in the previous) will often be larger than the difference between the set counts. You can validate this in Excel as shown in the attached Excel file.

I've changed the difference calculated to be conditional (if the old count is more than the new count, use the new count) so that we don't get the negative values and the total now is the true added records.

What do you think?

Arnie

[#3]

Nice work Arnie. Seems like it worked. Thank you very much !

Regards,
Shan Raj.