Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Chart showing Continuum of ID on year

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

2 Replies
Not applicable

Re: Chart showing Continuum of ID on year

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

Not applicable

Re: Chart showing Continuum of ID on year

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

Community Browser