Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'd like to ignore the selection of few filters in my dashboard.
num(only({$<Field1, Field2,FIELD1toIGNORE=,FIELD2toIGNORE=>} Dimension),'#.00%')
I used $ and = in set but when I select a field my chart disappears.
The chart is using static values from xl file and linked to fact using composite key.
Can anyone suggest how to ignore filter selection and give them static value?
Thanks.
With your current expression is it not ignoring? Can you share an example if possible?
No it's not.
I can't think of how to create a sample for this current scenario.
Cus the data I have is in millions and then there is a static file
The static file doesn't have link to the fields/Dim which I'm trying to ignore... It is just connected to Fact based on composite key.
But filters in front end has no connection to the static file.
Can you Mockup some data in excel and send it through. ?
ok, I'll.
thanks
It could be because you are using the "Only" function and you are more than one value in FIELD1toIGNORE and FIELD2toIGNORE fields.
Could you try with other funcion like MAX or MIN and study what happen?
So this goes blank when you make selection in one of these fields?
Field1, Field2, FIELD1toIGNORE, or FIELD2toIGNORE
or does it go blank on fields which are not listed above?
if Field1 and Field2 are selected it works fine.
But if I select FIELD1toIGNORE, or FIELD2toIGNORE which is not in Set Analysis, it makes the chart disappear.
Maybe, but I cannot use other than Only.
I do not want to calculate this field.
Dimension here is plain numbers and requirement is not to aggregate it.
As Sunny suggestion, Can you try like below
Sum({<Field1=, Field2=, FIELD1toIGNORE=, FIELD2toIGNORE >}Sales)