topic Re: Conditionally remove expression when any selection is made in QlikView

Conditionally remove expression when any selection is made

Mon, 28 Apr 2014 10:46:11 GMT

I need an expression to disappear from a chart when any selection is made in the following fields

Product

Region

Market

I am using the GetFieldSelections function in the Conditional box, but can't work out the correct syntax.

What would be the correct expression?

tresB — Mon, 28 Apr 2014 10:49:45 GMT

Use : GetSelectedCount(YourFieldName)

MK_QSL — Mon, 28 Apr 2014 10:55:16 GMT

Chart Properties

Layout Tab

Show Conditional

Type Below

=IF(GetSelectedCount(Product)+GetSelectedCount(Region)+GetSelectedCount(Market)>0,0,1)

Sorry, I misread.

Use above in Expression Condition.. in expression tab

rustyfishbones — Mon, 28 Apr 2014 10:55:55 GMT

Add this in the Conditional Show

dinuwanbr — Mon, 28 Apr 2014 11:01:53 GMT

Hi there,

In conditional state write =GetCurrentSelection(Product, Region, Market).

Hope this will solve your problem.

-Dinu1

vijetas42 — Mon, 28 Apr 2014 11:32:57 GMT

Hi,

Try this,

if(GetSelectedCount(Fieldname)>0,0,1) in your chart expression conditional where you need to hide

Regards,

Vijeta