Same effect as a Having SQL Clause

[#1]

Hi everybody, i'm a total newbie with QlikView and at this point i'm trying to make a search by a Sum()'s result. Let me try to explain it in details. We are dealing with sales and clients, my objective is to have a filter option that looks for clients with a X total in sales (A slider maybe).

HAVING SUM(Value_X) > 100000.00

The Sql Statement explains what i'm trying to get. I'm realy sorry for my english, its not my country's original language.

Hope you guys help me. Thanks.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

You can create a new slider object with an expression like

Aggr(Sum(Value_X), ClientID)

You will have then those values to slide and select them.

Hope that helps

[#3]

Hi Miguel, first of all thank you very much for ur answer. With ur example i was able to make a slider with this expression

=Aggr(Aggr(SUM(VALOR_VENDA),CODIGO_CLIENTE) - Aggr(SUM(VALOR_TROCA),CODIGO_CLIENTE),CODIGO_CLIENTE)

It works, but not like a filter, i mean, when i select a value on the slide bar, QlikView brings me the Clients i want, but after the first search

the slide bar is now working on the search result and not on the whole BI set of data. I think that this is happening because my expression

uses a calculation to look for a result and not a normal field that i believe is needed to be a normal filter.

Again, thank you so much for the support.

[#4]

I think that this image will help. The first one is the scale clean, with no selected range. The second shows a selection and finally the third one show the transformed slider, its now considering only the registers on the selected range. Can it be like a normal filter ? I mean u have to be able to select the values without having the slider affected by the result. You have to be able to rollback the filter if u want...

Thanks once again.

[Miguel_Angel_Baeyens]

Hi,

I think you always use the Go Back button or the Clear button to clear all selections done in any field as well as in the slider. Does that work for you?

Regards