topic Re: Input box in QlikView

Input box

Anonymous — Tue, 29 Apr 2014 15:21:22 GMT

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 — Tue, 29 Apr 2014 15:32:10 GMT

Create a Button

Add Actions as

External >> Set Variable

Variable

ExcludeKeyword

Value

=NULL()

maxgro — Tue, 29 Apr 2014 15:36:12 GMT

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

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

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

Count(Keyword)

)

fkeuroglian — Tue, 29 Apr 2014 15:37:05 GMT

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 — Tue, 29 Apr 2014 15:37:35 GMT

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)

tresB — Tue, 29 Apr 2014 15:38:51 GMT

Create a new variable like:

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

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