Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
anushree1
Specialist II
Specialist II

Ignore all selections except one filter

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

1 Solution

Accepted Solutions
mayankraoka
Specialist
Specialist

Hi,

Something like this:

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


Regards,

Mayank

View solution in original post

4 Replies
mayankraoka
Specialist
Specialist

Hi,

Something like this:

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


Regards,

Mayank

View solution in original post

paridhimantri
Creator
Creator

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
Master III
Master III

Hi,

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

Regards,

Antonio

P_Kumar
Contributor II
Contributor II

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