Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
louise119
Creator III
Creator III

Extension function

I would like to use an extension to display the table only when a required item is selected.
I'm using an if statement for the filter item.
How should I put the expression in the extended function?

I tried the below, but. I got an error(extension formula).

・filter formula:If(region='Japan' or region='US', Item )
・extension formula:GetSelectedCount("If(region='Japan' or region='US', Item )")>0

1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

If you are using conditional function in the Add on section of properties, formula to hide/show should be:

Count({<region={Japan, US}>}Item)>0

View solution in original post

3 Replies
Lisa_P
Employee
Employee

If you are using conditional function in the Add on section of properties, formula to hide/show should be:

Count({<region={Japan, US}>}Item)>0

louise119
Creator III
Creator III
Author

Thank you so much!

And how should I transfer the data from sheet to sheet?
I use "Count({<region={Japan, US}>}Item)>0" on filter , I can't transfer the data I selected to other sheet.

Lisa_P
Employee
Employee

Normally selections should apply to all sheets. When you create a calculated dimension, it depends on the logic you are using.

 for your filter (calculated dimension) try this formula:

Aggr(Only({<region={Japan, US}>} Item), Item)