topic Re: Ignore all selections except one filter in QlikView

Ignore all selections except one filter

anushree1 — Thu, 27 Apr 2017 07:33:28 GMT

Hi,

I would need to get the max of year ignoring all the selections except for a particular filter .

I know i could do sumthing like Month=,Dept=, etc to ignore the selections but that would be a lot of fields to ignore.

So is there something that i could use along with the all keyword anything for that matter to disrespect all the selections except for 1 i did try something like max (all<filter name > Year) but it does not work i also replaced all keyword with Total but that does not work either.

So please let me know how this could be accomplished

Re: Ignore all selections except one filter

mayankraoka — Thu, 27 Apr 2017 07:37:37 GMT

Hi,

Something like this:

Sum({1<FieldToKeep=P(FieldToKeep)>}Fieldname)

Regards,

Mayank

Re: Ignore all selections except one filter

Anonymous — Thu, 27 Apr 2017 07:47:25 GMT

Hi,

You can use alternate state ,You can make the same state of that filters and in expression use that state, this will solve your purpose.

Thanks

Paridhi

Re: Ignore all selections except one filter

antoniotiman — Thu, 27 Apr 2017 07:53:08 GMT

Hi,

Sum({1<Field=$::Field>} Value)

Regards,

Antonio

Re: Ignore all selections except one filter

P_Kumar — Mon, 07 Jan 2019 05:01:53 GMT

Thank you .. it's working for one filter.. what if there is requirement to consider only 2 or 3 filters. Kindly help. Thanks.

Re: Ignore all selections except one filter

TLX-QlikView — Mon, 30 Jan 2023 10:57:18 GMT

If you need to filter 2 or more fields you can add as comma separated expression as below

Sum({1<Field1=$::Field1, Field2=$::Field2>} Value)

It Works.

Thanks a lot