Jump to content

Try to find to Unique set of records for the Current Quater

Shamsundar Kulkarni

Recommended Posts

Hi, I have the below scenario where the table has records as mentioned:

Record As-of-Date

1 A Jan 2019

2B Feb 2019

3C Jan 2019

4D Current Quater

5ACurrent Quater


Here A appears twice- once on previous date and once in current quater.

Out of this table, i just want to filterD as it appears only in the current quater and doesn't have any record previosly.


Please let me know if this is possible to do with Spotfire


thanks in advance,


Link to comment
Share on other sites

Hi Sham,


You could aways set up a barchart, including subsets (check the All Data box). Then set up your filtering and select the current quarter. You will then see both A & C values present. As you have added the All Data subset, you can see that value A has an overall rowcount of 2. You can now mark value D and proceed with your analysis.

The attached dxp gives you a visual presentation of the above.

kind regards,

David Boot-Olazabal

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...