Auto Filter don't work

[kennykeins]

Hi everyone, my filter of the table don't want work.

i don't why:  

Sum(distinct PIPS)

[Or]

It's impossible to tell what your problem is from your post.. try being a little more specific / detailed - like including the base data, filter, and expected result.

[kennykeins]

The first 2 one's work well, as you see below the images:

Auto-Filter - Profit

when I add this writing, it no longer works in the background, but I need to distinguish my lines

if(Mod(RowNo(Total),2)=1,rgb(224,224,224),)

Thanks !

[Or]

Sorry, I still don't understand your problem.

1) None of your images are showing a filter. Did you perhaps mean sorting?

2) You aren't including the actual settings of your filter or sort, just the result table.

3) Your second post is showing something different from your first and I'm not sure what the actual problem is in either one.

[kennykeins]

Sorry 😓, you are right,

i will mean a sorting on my  table

[Or]

OK - now we just need to figure out the actual problem. What result were you expecting to get, and what are your sort definitions? 🙂

[kennykeins]

increasing and decreasing number for profit

[Or]

Guessing you mean PIPS, your profit looks like it's already sorted.

What is your sort order for this table and column? Would it be possible for you to attach a qvf file? That would make this much easier to look at.

[kennykeins]

The both don't work , it's because the script i added  for the color of line : 

if(Mod(RowNo(Total),2)=1,rgb(224,224,224),'')

[Or · Accepted solution]

Unfortunately, what you're trying to do is simply not allowed:

You could try using a third-party extension, such as Vizlib, to work around the problem. The screen capture below was taken when I converted your table to a Vizlib table. Note that these third-party extensions are not developed by Qlik itself and may require additional payment depending on your implementation and needs.