topic Anonymise customers in QlikView

Anonymise customers

kevbrown — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I've just looking at a PoC at the moment and was wondering if there's a way to produce a graph, based on customer sales for example but the labels for customers will show the customer selected and then for the rest of the customers state, "customer 1, customer 2, customer 3" and so on. Obviously when the customer selection is changed, that customer label is then visible and everything else is labelled as before, customer 1 etc

Thanks

Kev

Re: Anonymise customers

tresB — Mon, 26 Sep 2016 09:02:29 GMT

Could you explain a bit more may be with a sample data set?

Re: Anonymise customers

miguelbraga — Mon, 26 Sep 2016 09:02:30 GMT

Hey there,

Not sure you what you want, but try add these 4 expressions in you table:

For customer selected:

=Sum{Sales)

For customer 1:

=Sum{{$<Customer = ['customer 1'>} Sales)

For customer 2:

=Sum{{$<Customer = ['customer 2'>} Sales)

For customer 3:

=Sum{{$<Customer = ['customer 3'>} Sales)

Best regards,

D.A. MB

PS: if this doesn't solve your problem give us a better explanation and exemplify with sample of your data and the expected output.

Re: Anonymise customers

Anil_Babu_Samineni — Mon, 26 Sep 2016 09:15:47 GMT

I am not sure your intend, But as i understand you can use this

Aggr(Sum(Sales), Customers)

Re: Anonymise customers

sergio0592 — Mon, 26 Sep 2016 09:24:51 GMT

Maybe something like that:

=if(Customer =getfieldselections(Customer), Customer, 'Customer'&RowNo())

Re: Anonymise customers

jonathandienst — Mon, 26 Sep 2016 11:49:37 GMT

You could probably do this with a calculated dimension. I got this far:

=If(Index(GetFieldSelections(Customer, '|'), Customer), Customer, 'Other Customers')

So this will show the selected customers by name, and group the rest in 'Other Customers'. I have not been able to figure out a simple way in the front end to show the others with individualized names.

Re: Anonymise customers

jonathandienst — Mon, 26 Sep 2016 12:02:01 GMT

OK, this is closer to your original request:

If you define the customers as a dual like this:

LOAD Dual(Customer, RowNo()) As Customer,

Value

;

LOAD * Inline

[

Customer, Value

....

(You can use Rowno() like this or Autonumber() to get a distinct number for each customer)

Then you could use this expression:

=If(Index(GetFieldSelections(Customer, '|'), Customer), Customer, Dual('Other', Num(Customer)))

And the non-selected customers will be one line per customer, all labelled 'Other'. The value of the dual is used for the dimension, and they all have different values in spite of the same label.

Re: Anonymise customers

effinty2112 — Mon, 26 Sep 2016 12:59:21 GMT

Hi Kevin,

Add a listbox with field Customer and assign it to an alternate state such as PickCustomer, then try this calculated dimension:

=Aggr(if(Customer=only({PickCustomer}Customer),Customer, 'Customer ' & FieldIndex('Customer',Customer)), Customer)

Kind regards

Andrew

Re: Anonymise customers

sunny_talwar — Mon, 26 Sep 2016 13:47:31 GMT

May be it can be even done like this without alternate state

=Aggr(if(Only({<Customer>}Customer) = Customer,Customer, 'Customer ' & FieldIndex('Customer',Customer)), Customer)

Re: Anonymise customers

jonathandienst — Mon, 26 Sep 2016 14:05:45 GMT

Picking up a tip from Sunny's suggestion - no need to load Customer as a dual, use this instead:

=If(Index(GetFieldSelections(Customer, '|'), Customer), Customer, Dual('Other', FieldIndex('Customer',Customer)))