topic Re: Count function based on input variable in QlikView

Count function based on input variable

Tue, 07 Aug 2012 13:35:01 GMT

Hi experts,

i have the following situation:

I created a input box that''s sets a variable called vIncomeBorder.

Now i would like to show in a PIE chart (i think that is most obvious ?! ) how many people are below and how many above the variable are.

So I made the following expressions so far:

=Count({< Income =< $vIncomeBorder>} REGISTRATIONID // below

=Count({< Income => $vIncomeBorder>} REGISTRATIONID // above

what mistake do i make in the expressions??

giakoum — Tue, 07 Aug 2012 13:41:40 GMT

=Count({< Income ={"<=$(=('$(vIncomeBorder)'))"}>} REGISTRATIONID )

Tue, 07 Aug 2012 13:52:25 GMT

First thnx for your quick response.

If i try your expression it shows the PIE chart based on the income.

What i would like to achieve is the following:

i have the following data.

personId income

1 100

2 112

3 115

4 120

5 125

then i have a variable that is based on a input, let say variable = 118.

Then my pie chart must have two element.

one color that says 60% below

one color that says 40% above

giakoum — Tue, 07 Aug 2012 14:06:49 GMT

see attached.

Pie chart is not the best choice, I would use two descriptive text boxes instead.