Ignore Current Selection in Graph's Dimension Field

[tahirkhalil]

Hi,

Is there any possibility that Dimension in graph can ignore the current selection.

I have month, year and amount field as a sample. By default, I will be filtering data for latest month, but I need to show the overall position of some field (amount in my sample case) based on months.

How can I ignore current selection in graph dimension. I understand that this can be done via set analysis - but it is possible in expression.

See the attached sample doc.

Some ideas please?

Regards,

TK

settu_periasamy‌engishfaque‌

[sunny_talwar]

You sure can. Are there specific field selections you want to ignore or all selections need to be ignored?

For all selections try this -> Sum({1}SomeAmount)

For specific field selections try this -> Sum({<Field1, Field2, Field3}>}SomeAmount)

[kkkumar82]

Hi,

Other than this if selections should not happen after data being loaded go for "Detached " in Properties -> general tab of the chart.

Thanks

Kiran Kumar

[kkkumar82]

Hi Sunny,

I think second one should be like this

Sum({<{Field1=, Field2=, Field3=}>}SomeAmount)

Regards

Kiran Kumar

[sunny_talwar]

Well I def. missed a closing curly brackets but don't think excluding = sign makes any difference

[udaya_kumar]

Hi Tahir,

If you want to ignore all the current selections irrespective of the field selection, then you can try this

Sum({1-$} Amount)

[kkkumar82]

Hi Sunny, Really feeling great knowing that "=" is not necessary. This is what I see in help

Thanks

Kiran Kumar

[sunny_talwar]

Here is an example:

[tahirkhalil]

Hi

As I mentioned, my data is monthly and the user will be able to select only single month data (although this functionality is not in the sample). By default the data will be filtered for whole month but I need to show a bar/line chart with all the months.

Now if the data is already filtered on month field, how can I create a dimension of field month having all non*filtered values?

In expression, yes a sets can be used to ignore the filter but what should be done to create dimensions?

I think am able to clarify the issues?

See the attached sample doc, without filter I have line chart showing monthly values but once I select a month, it show only that month in chart. I want to keep this chart as it is even if someone selected/filter data.

Regards,

Tahir

• This message has been sent using QMobile A8 ***

[sunny_talwar · Accepted solution]

Expression:

Sum({<MonthNum, YearNum>}SomeAmount)