topic Hide line in chart while making selection in cyclic group in QlikView

Hide line in chart while making selection in cyclic group

Wed, 26 Aug 2015 07:26:41 GMT

Hi All,

I have a line chart with 3 expressions, and I need to hide one among them when the cyclic group(Calendar) in that chart is other than Month.

Please help me with the solution.

Thanks

Saritha Xavier

jagan — Wed, 26 Aug 2015 07:58:28 GMT

Hi,

Try like this

Chart Properties -> Expression -> Click on the expression -> Select Conditional option and give below expression

=GetCurrentField(Calendar) = 'Month'

Note: Replace Calendar with the Group name

Month with the actual field name.

Hope this helps you.

Regards,

jagan.

Wed, 26 Aug 2015 07:59:55 GMT

Hi All,

i got the solution for this

=if(GetCurrentField(Cal) = 'Month Year_S', 1,0)

Thanks

Kushal_Chawda — Wed, 26 Aug 2015 08:00:17 GMT

Please post the sample app

jagan — Wed, 26 Aug 2015 08:06:05 GMT

Hi Sarita,

No need of If() you can simply give like below

=GetCurrentField(Cal) = 'Month Year_S'

Hope it helps you.

Regards,

Jagan.

Wed, 26 Aug 2015 08:09:54 GMT

Thanks Jagan,

Yes No need of if() , without if () also it is working fine.