Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Create a new variable like:
Variable1=If(Len('$(ExcludeKeyword)')=0, '','*$(ExcludeKeyword)*')
Then expression: =Count({<[Keyword]=-{'$(Variable1)'}>}Keyword)
Create a Button
Add Actions as
External >> Set Variable
Variable
ExcludeKeyword
Value
=NULL()
if I understand you can check if there is something to exclude
if(len(trim('$(ExcludeKeyword)'))>0,
Count({<[Keyword]=-{'*$(ExcludeKeyword)*'}>}Keyword),
Count(Keyword)
)
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
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)
Create a new variable like:
Variable1=If(Len('$(ExcludeKeyword)')=0, '','*$(ExcludeKeyword)*')
Then expression: =Count({<[Keyword]=-{'$(Variable1)'}>}Keyword)