Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have been looking for this particular question but I have found nothing.
I have a date filter in the field "fecha_act". But this filter is done by means of autocalendar (YearMonth) so the expresion is:
"=[fecha_act.autoCalendar.YearMonth]"
So when filtered this is what I see:
What I want to achieve is to create a line-chart with "=[fecha_act.autoCalendar.YearMonth]" as the dimension, but with measures not affected by the filter so, no matter the filter, I want to see the whole time line
I have used this Set analysis expression in the measure: Avg({$<[fecha_act.autoCalendar.YearMonth] =>}avance)
but the chart shows the results filtered by that date.
Any clues?
Thank you in advance!
Accepted Solutions
Hi, Andrey.
Your example was not the solution but was very helpful for finding the problem.
I tried to replicate my problem within your qvf and I could do it, so the "bug" still exists.
The trick:
When you assign a dimension to a filter pane, you select it from the filed list just like the following:
So when you hit "Apply" button what you see is the following:
That "equal" symbol is the problem. If this is left like that, in the upper filter bar what yo see is:
In this situation, the Set Analysis expression I posted does not work. What we need the filter to be is the following:
Please, note that now the equal symbol is not there. And now, the Set Analysis Expression is working properly.
The only way to achieve this is to manually delete the equal symbol within the filter pane properties panel:
Now, every filter works correctly and the set analysis expressions do what they are supposed to do.
I think this is some kind of bug and I hope this to be helpful to people with the same problem.
Greetings!
Hi, Andrey.
Your example was not the solution but was very helpful for finding the problem.
I tried to replicate my problem within your qvf and I could do it, so the "bug" still exists.
The trick:
When you assign a dimension to a filter pane, you select it from the filed list just like the following:
So when you hit "Apply" button what you see is the following:
That "equal" symbol is the problem. If this is left like that, in the upper filter bar what yo see is:
In this situation, the Set Analysis expression I posted does not work. What we need the filter to be is the following:
Please, note that now the equal symbol is not there. And now, the Set Analysis Expression is working properly.
The only way to achieve this is to manually delete the equal symbol within the filter pane properties panel:
Now, every filter works correctly and the set analysis expressions do what they are supposed to do.
I think this is some kind of bug and I hope this to be helpful to people with the same problem.
Greetings!