Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Making Filter as Inverted.

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

1 Solution

Accepted Solutions
itberatung24
New Contributor III

Re: Making Filter as Inverted.

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

6 Replies
Not applicable

Re: Making Filter as Inverted.

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

Kiran.

itberatung24
New Contributor III

Re: Making Filter as Inverted.

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

Regards

Norbert

Not applicable

Re: Making Filter as Inverted.

Hi Norbert,

                 How should i do that?

Thanks and Regards,

Manikanta

itberatung24
New Contributor III

Re: Making Filter as Inverted.

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.

Try this

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

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

Not applicable

Re: Making Filter as Inverted.

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

Community Browser