topic Re: Ignore Current Selection in Graph's Dimension Field in QlikView

Ignore Current Selection in Graph's Dimension Field

tahirkhalil — Wed, 13 Jan 2016 09:57:40 GMT

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,

settu_periasamy‌engishfaque‌

Re: Ignore Current Selection in Graph's Dimension Field

sunny_talwar — Wed, 13 Jan 2016 13:34:51 GMT

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)

Re: Ignore Current Selection in Graph's Dimension Field

kkkumar82 — Wed, 13 Jan 2016 13:39:21 GMT

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

Re: Ignore Current Selection in Graph's Dimension Field

kkkumar82 — Wed, 13 Jan 2016 13:41:41 GMT

Hi Sunny,

I think second one should be like this

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

Regards

Kiran Kumar

Re: Ignore Current Selection in Graph's Dimension Field

sunny_talwar — Wed, 13 Jan 2016 13:48:06 GMT

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

Re: Ignore Current Selection in Graph's Dimension Field

udaya_kumar — Wed, 13 Jan 2016 13:52:34 GMT

Hi Tahir,

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

Sum({1-$} Amount)

Re: Ignore Current Selection in Graph's Dimension Field

kkkumar82 — Wed, 13 Jan 2016 13:59:41 GMT

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

Thanks

Kiran Kumar

Re: Ignore Current Selection in Graph's Dimension Field

sunny_talwar — Wed, 13 Jan 2016 14:28:21 GMT

Here is an example:

Re: Ignore Current Selection in Graph's Dimension Field

tahirkhalil — Wed, 13 Jan 2016 14:40:47 GMT

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 ***

Re: Ignore Current Selection in Graph's Dimension Field

sunny_talwar — Wed, 13 Jan 2016 17:20:50 GMT

Expression:

Sum({<MonthNum, YearNum>}SomeAmount)

Re: Ignore Current Selection in Graph's Dimension Field

tahirkhalil — Thu, 14 Jan 2016 05:32:22 GMT

I never thought this way -

Thank you very much to explain this.

Re: Ignore Current Selection in Graph's Dimension Field

sunny_talwar — Thu, 14 Jan 2016 17:36:29 GMT

No problem. I am glad we were able to help you out here

Re: Ignore Current Selection in Graph's Dimension Field

Akina0929 — Tue, 11 Oct 2022 14:16:52 GMT

Hi Sunny,

I have the same requirement, I have used sum({<month=>}sales) as expression and month as dimension, it is showing only dimension values on x axis only but no data in Y axis. can you please help me in this scenario.

Thanks In Advance,