Ignore all selections except one filter

[anushree1]

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

[mayankraoka · Accepted solution]

Hi,

Something like this:

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

Regards,

Mayank

[Anonymous]

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

[antoniotiman]

Hi,

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

Regards,

Antonio

[P_Kumar]

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

[TLX-QlikView]

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