Programmatically filter dimension based on aggregated value

Mon, 08 Feb 2016 16:17:56 GMT

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

Re: Programmatically filter dimension based on aggregated value

Gysbert_Wassenaar — Mon, 08 Feb 2016 17:30:58 GMT

Try this expression as search expression:

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

Re: Programmatically filter dimension based on aggregated value

Tue, 09 Feb 2016 07:55:46 GMT

Hi Gysbert,

it works..!

Thanks so much for your help

Salvo

topic Programmatically filter dimension based on aggregated value in QlikView

Programmatically filter dimension based on aggregated value

Re: Programmatically filter dimension based on aggregated value

Re: Programmatically filter dimension based on aggregated value