topic Re: Making Filter as Inverted. in QlikView

Making Filter as Inverted.

Tue, 10 Jul 2012 04:26:39 GMT

Hi All,

I am having a filter which has 100 entries suppose.I want to view 90 entries data only in the report.I want to select those 10 entries in the filter and i want to see the data other then the selected entries data.i.e., i want to make filter as inverted filter.Is there any way to acheive it?

Thanks in Advance,

Manikanta

Re: Making Filter as Inverted.

Tue, 10 Jul 2012 04:42:53 GMT

Use {<1-$>} in the set analysis.

Kiran.

Re: Making Filter as Inverted.

Anonymous — Tue, 10 Jul 2012 04:52:41 GMT

I would use "select excluded" as an action in a button applied on the dimension.

Regards

Norbert

Re: Making Filter as Inverted.

Tue, 10 Jul 2012 06:47:31 GMT

Hi Norbert,

How should i do that?

Thanks and Regards,

Manikanta

Re: Making Filter as Inverted.

Anonymous — Fri, 13 Jul 2012 19:27:25 GMT

Manikanta,

you create a button, go to Actions

Add "Action Type" Selection, Action "Select Excluded"

then select the Field you want to apply it to.

Regards

Norbert

Re: Making Filter as Inverted.

CELAMBARASAN — Fri, 13 Jul 2012 19:45:27 GMT

Try this

Sum({<FieldName=E(FieldName)>} Field2)

Which give sum of the field2 values by excluding the selection made FieldName filter.

Re: Making Filter as Inverted.

Mon, 16 Jul 2012 06:05:08 GMT

Hi All,

Thanks for the reply.I have found some other way to achieve this.Create a list box object right click go to properties -> caption -> special icon - > check the selectexcluded icon. and apply

This would solve my problem

Regards,

Manikanta