Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Jsobrinho77
Creator
Creator

ignore filter in rank function

Hi guys,

I have a rank function that needs to ignore some fields, but not working. how can I ignore the filter using the rank function?

aggr(

if( rank

 if(sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure)<>0,

sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure))

)<=5, only({<FIELD1>} Dim)),Dim)

 

If I included in the KPI only the sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure) the selection by FIELD1 will be ignored, this is ok, but using the full measure with rank not ignore

Labels (1)
2 Replies
vincent_ardiet_
Specialist
Specialist

Maybe with Aggr({<FIELD1>} ... ?

Jsobrinho77
Creator
Creator
Author

first of all, thank you for your answer...

But not ignored yet.

if I selected a type of the FIELD1, show 3 values, but without this selection I will wait 5, because the rank without this selection is 5.

I'm tried 

 

Only( {<FIELD1>}

aggr(

if( rank

 if(sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure)<>0,

sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure))

)<=5, Dim)),Dim))

But this retunr: Invalid dimension