Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this expression as search expression:
='(' & concat({<ID={"=sum(value)>=0.1"}>} distinct ID,'|') & ')'
Try this expression as search expression:
='(' & concat({<ID={"=sum(value)>=0.1"}>} distinct ID,'|') & ')'
Hi Gysbert,
it works..!
Thanks so much for your help
Salvo