topic Filter field before putting it in the selection active in QlikView

Filter field before putting it in the selection active

Wed, 01 Jul 2015 16:32:41 GMT

Hello,

I start on QlikView.

I would build a calculated field that I can use in a button with the action "select the possible values."

Detail:

I want to create a button with the action "select possible values" on the "consumer code" field.

Except that in fact instead of doing it on the field "code consumer" I'd like to do it on an expression. because I need to filter the list of consumers. I want the consumers for whom: $ (vCalcConso)> 0

I can do a counting indicator: = sum ({$ <= {"= $ (vCalcConso) 0 [conso Code.]>"}>} COUNT_CONS_ID) which works very well.

I can make a selection list with all my consumers and displayed next to the words:

the expressions $ (vCalcConso) then the expression: if ($ (vCalcConso)> 0 [conso Code.]), and it works well.

but when I put directly if ($ (vCalcConso)> 0 [conso Code.]) as field value, that nothing brings me to my selection list.

my goal: I want to have an object that list me as clients for which $ (vCalcConso)>0 and that puts the consumer code filter list in the active selection.

Actually I do not want to have a list of these customers filtered on the screen because I can have in the 500 000 customers ...

thank you for your help.

Magali

Re: Filter field before putting it in the selection active

Gysbert_Wassenaar — Thu, 02 Jul 2015 11:07:55 GMT

Except that in fact instead of doing it on the field "code consumer" I'd like to do it on an expression.

That's not possible. Expression values cannot be selected.

because I need to filter the list of consumers. I want the consumers for whom: $ (vCalcConso)> 0

You can try using an advanced search to select those customers and create a bookmark for that search. Or you can try implementing the condition in (set analysis) expressions in your charts.

Re: Filter field before putting it in the selection active

Fri, 03 Jul 2015 10:23:52 GMT

VCalcConso is already a set analysis very complex and I cannot put it everywhere it would cause bad réponse time.
In fact today I put a graph "scatter chart" or points represents consommateurs corresponding to my set analysis.

Then the users select all the points and it puts all the consumers in filter in the active selection, then they can go to consult other graphs.

But the display in Internet exporer of a "scatter chart" with a lot many points is too heavy.

I shall thus like ignoring this stage, and making a button which would allow to tip over directly the consumers in active selection without needing to show the "scatter chart"...

with set analysis, I can' create customer's list who correspond to a condition?

Magali

Re: Filter field before putting it in the selection active

Thu, 23 Jul 2015 09:56:16 GMT

Hello to all,

I share the profit of my researches) because I found an answer to my problem.

In fact by looking in the community I realized that I could cross in advanced search on the code consummer, a test on my complicated indicator (filled with set analysis):

And this filter did well for what I waited.

I created a button with two actions:

1/ an action(share) where I filter my dimension with in condition my great complicated indicator

2/ and as I prefer that my users can see customers' nb, an action which tips over the customers of the selection in " selection "