Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Conditionally remove expression when any selection is made

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: Conditionally remove expression when any selection is made

Use : GetSelectedCount(YourFieldName)

5 Replies
MVP
MVP

Re: Conditionally remove expression when any selection is made

Use : GetSelectedCount(YourFieldName)

Re: Conditionally remove expression when any selection is made

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
Honored Contributor II

Re: Conditionally remove expression when any selection is made

Add this in the Conditional Show

2014-04-28_1154.png

2014-04-28_1155.png

dinuwanbr
Contributor III

Re: Conditionally remove expression when any selection is made

Hi there,

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

Hope this will solve your problem.

-Dinu1

vijetasharma
Contributor III

Re: Conditionally remove expression when any selection is made

Hi,

Try this,

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

Regards,

Vijeta

Community Browser