Ignore selections between two fields

[nihhalmca]

Hi All,

I need to Ignore selections between two fields, for instance

- if i do selections in Year1, Year2 has to ignore these sections and same way if i do selections in Year2, Year1 has to ignore these sections.

Can you know the solution please?

Attached Sample.qvw here.

Thanks,

Nihhal.

[jmvilaplanap]

Hi,

You can try with a trigger, when you select a field, you can clean another one.

Regards

[sunny_talwar]

Is this for a chart? May be this

=If(GetSelectedCount(Year2) > 1, Sum({<Year1>}Measure), Sum({<Year2>}Measure))

[nihhalmca]

Hi Sunny - yes for chart.

As per your logic, if i select 2015 in Year1 filter it will work as expected until i select Year2 once i select value in Year2 it overwrite Year1 filter.

My requirement is some fields should reflect by Year1 and some fields should reflect by Year2 filters in straight table

[sunny_talwar]

Would you be able to share a sample to show what exactly you mean?

[nihhalmca]

I could not attach sample now Sunny.

Straight question that chart which should reflect by Year1 and Year2 filters. Condition is should not over write both the filter selections

[sunny_talwar]

Straight answer, I am still not sure I understand. May be someone else might be able to help you better unless you are able to explain better with an example (if not a sample).

Best,

Sunny

[sudhirpkuwar]

Hi,

Just adding on to Sunny's solution

=If(GetSelectedCount(Year2) > 1, Sum({<Year1,Year2=>}Measure), Sum({<Year2,Year1=>}Measure))

just write Field name and (=) and leave it

May be this can help you out

Regards,

Sudhir

[nihhalmca]

Ok sunny. I have attached Sample.qvw at original question.

[nihhalmca]

Tried, not working sudhir.