topic expression in list box: grouped in QlikView

expression in list box: grouped

chriscools — Wed, 02 Nov 2011 22:01:45 GMT

Hello,

what do i have to do if i want to make an expression in a list box, but is has to sum of values per client.

so what i want to see is not al the values, but only one value (total) per client.

because i have to make it possible for people to search values above a certain free to choose value.

and my idea was to do this with the search function of a list box, and then search on (for example): >2000

can someone help me?

thanx!

expression in list box: grouped

Oleg_Troyansky — Wed, 02 Nov 2011 22:06:22 GMT

Use advanced aggregation:

AGGR(sum(Values), ClientID)

expression in list box: grouped

chriscools — Wed, 02 Nov 2011 22:46:29 GMT

Hey Oleg,

thanx! that was what i needed!

grtz,

chris

expression in list box: grouped

Thu, 03 Nov 2011 05:03:13 GMT

Hi Oleg,

I check with your above expression its working but it is showing the particular client value & also the total value, but i do not want to show the total value in list box , i just want to show the particular clientID total only not whole total.

Hope you understood.

Regards,

Antony.

Re: expression in list box: grouped

Thu, 03 Nov 2011 09:39:50 GMT

Hi Antony,

What my understanding from your post is

You want to dispaly only one clientid total in another listbox if you select particular clientid from another listbox

if it is right then, try this expression

=If(GetSelectedCount(ClientID)>0,AGGR(sum(Values),ClientID))

Let me know what i thought is correct or not!!!

Regards..

Re: expression in list box: grouped

Thu, 03 Nov 2011 10:13:14 GMT

Hi Ravi,

Thanks for your reply..

Its showing when click that clientID, how do i show particular clientID total without selecting.

Regards,

Antony.

Re: expression in list box: grouped

Thu, 03 Nov 2011 10:24:27 GMT

If you want to show the total values of a Client ID inside the same listbox you can simply add the formula aggr(sum(Values),ClientID)