topic Dynamic Caption - Active filter based condition in QlikView

Dynamic Caption - Active filter based condition

Mon, 17 Feb 2014 09:50:56 GMT

Hello,

I am trying to create a dynamic caption, where I want to put a condition if particular filter is active then return that filter name else some default.

I was able to do it with Month filter but not able to do it for non dates variables.

if(only(month),'Vs.Segment','Vs.Total')

could anyone possibly help?

Thanks,

Varun Singhal

Re: Dynamic Caption - Active filter based condition

MK_QSL — Mon, 17 Feb 2014 09:57:56 GMT

Use something like below

=IF(GetSelectedCount(Month) > 0,'Vs.Segment','Vs.Total')

Re: Dynamic Caption - Active filter based condition

Mon, 17 Feb 2014 10:03:55 GMT

Thanks Manish, It worked!!

Kind Regards,

Varun Singhal