topic Re: Ignore selections between two fields in QlikView

Ignore selections between two fields

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Ignore selections between two fields

jmvilaplanap — Wed, 06 Jun 2018 09:06:41 GMT

Hi,

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

Regards

Re: Ignore selections between two fields

sunny_talwar — Wed, 06 Jun 2018 09:07:28 GMT

Is this for a chart? May be this

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

Re: Ignore selections between two fields

nihhalmca — Wed, 06 Jun 2018 10:17:35 GMT

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

Re: Ignore selections between two fields

sunny_talwar — Wed, 06 Jun 2018 11:09:35 GMT

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

Re: Ignore selections between two fields

nihhalmca — Wed, 06 Jun 2018 11:24:13 GMT

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

Re: Ignore selections between two fields

sunny_talwar — Wed, 06 Jun 2018 11:25:51 GMT

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

Re: Ignore selections between two fields

sudhirpkuwar — Wed, 06 Jun 2018 11:33:39 GMT

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

Re: Ignore selections between two fields

nihhalmca — Wed, 06 Jun 2018 12:31:01 GMT

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

Re: Ignore selections between two fields

nihhalmca — Wed, 06 Jun 2018 14:35:05 GMT

Tried, not working sudhir.

Re: Ignore selections between two fields

jyothish8807 — Fri, 08 Jun 2018 05:08:14 GMT

Hi Nihhal,

Please refer the attached/ I have just modified the Actual Val expression, if it works the same can be done for rest.

Br,

Re: Ignore selections between two fields

vijetas42 — Fri, 08 Jun 2018 07:31:31 GMT

can't you use alternate states here?