Bar chart with zoom capability

[#1]

Hi I have a sales data table that has monthly sales amount projections for next 20 years. i like to create a bar chart that displays the sales data by year first, but if you zoom then it shows by quarter and upon further zoom by month. is this doable in qlik, sorry i am new.

sales	month/year
456,736.00	9/16
4,432,345.00	10/16
3,432,344.00	11/16
3,344,234.00	12/16
433,334.00	1/17
2,223,432.00	2/17

thanks nikit

[MK9885]

As far as I know you cannot have a drill down selection to Quarters if you select multiple years.

Cus when you select more than 1 year at a time then it will show you data for 4 quarters (Q1,Q2,Q3,Q4).

And if you want to see data for only 2 or 3 quarters then you've to do it through Quarter Filter.

Select more than 1 year and then select the desired Quarter you want to see.

[sunny_talwar]

May be it can be done using conditional dimensions? If a value is selected in Year field, Year dimension goes away and Quarter is activated and so on....

[sunny_talwar]

Like the attached

[MK9885]

I've tried at my own qvw using if(getselectedcount(year)>=1,.....

and also tried with conditional expression

if(getcurrentselection(year)....

and it doesn't seem to work with multiple years. Like if I select 2011 and 2012 at same time then it shows only year but not break it down into all 8 (2011, 2012) quarters.

If I understood his question correctly, this is what he is seeking? Not an expert but I don't know.

[sunny_talwar]

I might have missed the requirement, but can you check the qvw I have attached above?

[MK9885]

Oh yes!!

As always you know how to do it.

Thanks, I learned something new today.

I hope nikitmehta will get his answer in your sample qvw.

[MK9885]

But will it also work if we using the Year,Quarter and Month as Groups?

If not then maybe he has to add individual dimensions as you did.

[sunny_talwar]

The only thing which might be more helpful here would be to use QuarterYear and MonthYear instead of Quarter and Month because selecting multiple years will group all those Quarters into one... So may be like this....

[sunny_talwar]

Drilldown group won't work (just as you pointed out) and the op will need to use multiple dimensions with hide/show

[MK9885]

Oh ok got it.

It was helpful for me with both the examples you've provided.

Thanks.