🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Error when using Filters by values with measure active false

Ravi asked on December 11, 2019

Hi Team,
We tried to add filters and hide measures by using active false. then its showing console error instead of showing data.
To reproduce this, we made a below fiddle. Please get it.

"measures": [
"uniqueName": "Net_Sales"
"uniqueName": "Avg_Check"
"uniqueName": "Check_Count",
"active": true

in the above measures change “active” :false and run the jsfiddle example, then you will get the console error.

4 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 11, 2019

Hello, Ravi,
Thank you for your question.
The reason of the error is that the filter is applied to the inactive measure. Removing the filter resolves the problem.
Our team is going to fix the problem with arising of the error with the minor update ETA Dec 30; however, we would like to kindly draw your attention to the fact that the filtering is impossible by the value that is absent in the current slice, so the specified filter will be ignored.
We have changed the fiddle you have provided, so the error is removed. The fiddle itself can be found by the following link: https://jsfiddle.net/flexmonster/m78fwu1k/.
Please, contact us in case of additional questions.
Kind Regards,

Ravi December 11, 2019

Hello Illia,
Thanks for your quick reply. Actually the issues happened while we are using filters by value and measure active = false. our aim is to show calculated fields only, should not show measures but need to filter based on inactive measures. if you give us the fix for this, that could be great. thanks again . 

Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 13, 2019

Thank you for your feedback.
We would like to kindly inform you that the value can not be chosen for filtering until it is not presented in the current slice and its active property is not set to true.

Mykhailo Halaida Mykhailo Halaida Flexmonster December 31, 2019

Hi Ravi,
We are glad to announce that the issue when using the inactive measure in values filter was fixed.
This is available in the 2.7.22 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if everything works fine.
Looking forward to hearing from you.
Best regards,

Please login or Register to Submit Answer