Input box

[Anonymous]

Hi guys,

I have a chart and input box, where I select what I want to excluded from my chart.

For example: if I typed excluded  COAT,

then I want to see all results. If I keep empty input box, the chart - no data to display.

What trick should I use  to see all results?

Please see my attached file.

[MK_QSL]

Create a Button

Add Actions as

External >> Set Variable

Variable

ExcludeKeyword

Value

=NULL()

[maxgro]

if I understand you can check if there is something to exclude

if(len(trim('$(ExcludeKeyword)'))>0,

Count({<[Keyword]=-{'*$(ExcludeKeyword)*'}>}Keyword),

Count(Keyword)

)

[fkeuroglian]

Hi, you have to put  a " . " to display all the data in the chart

if see in detail, the "." appears when you have no selections, then you put "coat" and delete de " . "

good luck

Fernando

[Anonymous]

Thanks Manish,

There is no other way, except of create a button.

Use for example Variable Event triggers like this

=if(len(ExcludeKeyword)=0,Null(),ExcludeKeyword)

[tresesco · Accepted solution]

Create a new variable like:

Variable1=If(Len('$(ExcludeKeyword)')=0, '','*$(ExcludeKeyword)*')

Then expression: =Count({<[Keyword]=-{'$(Variable1)'}>}Keyword)