Change the measure when using drill-down chart - Qlik Community

agg · ‎2019-03-18

Hi all,

I'd like to change the measure when using a drill-down line chart.

My dimension is FiscalYear - FiscalYearMonth and my line chart shows the real accomplishment vs goal accomplishment. However, I'd like to show goal accomplishment only with FiscalYear and hide it when showing FiscalYearMonth.

I've found GetCurrentField but as far as I know, it's not working in QlikSense.

Is it posible to do what I need?

Thanks in advance.

Regards.

àlex

Channa · ‎2019-03-19

try to work with Add-ons under data handling

like IF(Count(FacialYear)>1 , sales)

Channa

vikasmahajan · ‎2019-03-20

PFA sample see if this can help you.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

agg · ‎2019-03-21

Thanks!

I'm gonna take a look

agg · ‎2019-03-21

Thanks for your help!

I'll try to do what you suggested.

agg · ‎2019-03-21

Hi Vikas,

Thanks for your reply.

When I open the .qvf I get this.