Programmatically filter dimension based on aggregated value

[#1]

Hello All,

I'm pretty new on QLikView platform and I'm working on my first project.

Usually all doubts I had are solved, just, reading this community forum, but this case is the exception: I didn't find nothing.

I have a table with two fields: ID (auto-number) and value. I can have several values for same ID.

Now I want to create a button that excludes all ID where sum of values are less than 0.1

Usually, I create an histogram with dimension floor(aggr(sum(value), ID), 0.1) and expression count(value), then I filter for value greater than 0.1.

I tried to use a button with "select in field" action using following condition: =Aggr(if(sum(value='>0.1', ID), ID)

but it doesn't work.

Can someone help me?

Thanks in advance,

Salvo

[Gysbert_Wassenaar · Accepted solution]

Try this expression as search expression:

='(' & concat({<ID={"=sum(value)>=0.1"}>} distinct ID,'|') & ')'

[#3]

Hi Gysbert,

it works..!

Thanks so much for your help

Salvo