Help in Drill Down Group

[sayadutt]

Hi Team,

I am trying to create a Drill down group based on Year, Month and date of "Go Live Date" field.

So, this Go Live field list box should drill down from Year, Month and date.

Now, the problem I am facing is: the Month is taking the corresponding month from multiple years.

So, if I click 2015 => Jan,  I am expecting only 2015 Jan data, but its displaying 2014 Jan , 2015 Jan, 2016 Jan ..... data.

My requirement is once I click on 2015 year, it should drill down to 2015 months only (instead on showing 2014, 2015 , 2016 months)

How can I only display 2015 corresponding months only when 2015 year is clicked??

Thanks

[qlikmsg4u · Accepted solution]

Easy way is create Year and Month in script level the use those fields in Drill down group

[nagarjuna_kotha]

PFA...