Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
When i filter brand = BEC
How can i prevent my line chart not affected ?
Paul
Hi All
I mean how to modify the expression , so that it will ignore user selection. Just like SET analysis , even i select month = jan , it will still display all date sales.
Paul
Detach, If you want the chart to not change at all. (Right click on chart and Detach)
Hi Sir
Any other alternative , as your suggestion is not suitable for me.
Paul
Your original expression:
money(
sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)
, $(vMoneyFormatK))
You can ignore selections in specific fields by adding them into the set analysis with just Field= (see Brand below):
money(
sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, Brand=>}$(ColumnDim51)/$(Columndim89)/1000)
, $(vMoneyFormatK))
You can ignore all selections by using a 1 in the set analysis instead of the $:
money(
sum({1<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)
, $(vMoneyFormatK))
You can also ignore all selections by giving the chart a different alternate state than the rest of the document.
Hi Paul,
check out my suggestion.
Greetings
Roland
Hi Sir
Now i like to learn from you how to add one more field in the expression. So that when user click on GROUP_CLASS field label , it will not affect the chart.
Hi Paul,
normally this (new) part of SET Analysis of your expression would do the job:
. . . . $<BRAND_ =, GROUP_CLASS=, . . ..
But as you can see, for some reasons month is undefined for GROUP_CLASS= "G". So when your user selects "G" the expression becomes undefined (see arrow) and the chart has nothing to calculate.
Good Night
Roland