Visualization only reacting to custom filter pane

Mon, 14 Mar 2016 12:32:19 GMT

Hello.

I encounter a strange problem when i make a selection from a filter pane which i edited to only show curtain values, the expression looks like this:

if(Match([Field1],’Text1’ ,'Text2’,' Text3',' Text4',' Text5',' Text6'),[Field1])

The filter pane looks right and I can also make the right selections.

Then I have a line chart with 6 different lines, which all is related to the “Textx”, in the filter pane. The expression for one of them looks like this:

((sum({$<Type={‘Type1’},Year={'2015'},[Field1]={‘Text1‘}>} Data )-sum({$<Type={'Type1’},Year={'2014'},[Field1]={‘Text2’}>} Data))/sum({$<Type={‘Type1’},Year={'2014'},[Field1]={‘Text2’}>} Data ))

Field1 and Text1 and Text2 is both equal to the ones in the filter pane, and when I make an selection in the filter pane the visualization reacts as intended.

The problem begins when I make a selection in a filter pane on another sheet with Field1 (as in the custom filter pane) as dimension but this filter pane is not custom made to only have the 6 values. Whenever I select something in this filter pane the line charts with the 6 different lines does not react and a selection is not made in the custom made filter pane.

Anyone know what is causing this?

topic Visualization only reacting to custom filter pane in App Development

Visualization only reacting to custom filter pane