Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Group,
I am looking for Chart to Display ID Continuum on button click.
Say I have Condition:
1. Select 2002 and 2004 from Year List Box.
2. Now in Table box it should only display Only ID's present in all 2002 , 2003 and 2004.
3. If any ID is not available in 2003 but was available in 2002 and 2004, this ID should not appear in chart.
** Looking for your quick favor..... attached is the sample QVW
--
Thanks & Regards
Ashwin Pagare
Hi Ashwin,
The button should apply an advanced filter that compares the current selection of years to the years associated with each ID. The formula I used in the attached file is
='=GetFieldSelections(Year)=concat(distinct Year,' & chr(39) & ', ' & chr(39) & ')'
I hope that helps.
Regards, Karl
Thanks Karl.... its works.
I really loved the logic you suggested. I was struggling nearby the same but missed out this. Thanks for the quick help.
--
Thanks & Regards
Ashwin Pagare