Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vovan4ik
Specialist II
Specialist II

Input box

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.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Create a new variable like:

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

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

View solution in original post

5 Replies
MK_QSL
MVP
MVP

Create a Button

Add Actions as

External >> Set Variable

Variable

ExcludeKeyword

Value

=NULL()

maxgro
MVP
MVP

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

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

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

Count(Keyword)

)

fkeuroglian
Partner
Partner

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

vovan4ik
Specialist II
Specialist II
Author

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
MVP
MVP

Create a new variable like:

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

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

View solution in original post