Updating Table Values after Data Load - Qlikview

Anonymous — Thu, 18 Jan 2018 20:32:25 GMT

Hi Guys,

I am currently working on a Benchmarking tool which will be used to compare a single Country (Benchmark Country - BMC) to a selected Pool of Countries (PoolC) in several KPIs. I have a table with the following structure:

Country	KPI	System	Value
Portugal	KPI 1	A	10
Italy	KPI 1	D	15
Italy	KPI 3	B	20
USA	KPI 2	C	35
...	...	...	...

To illustrate which Systems may need improvement I finally want to end up with a table in the following form for each KPI:

KPI N:

System	BMC	Pool Mean	Delta: BMC - Pool Mean
A	10	15	-5
B	20	15	5
C	30	10	20

Since the selection of BMC as well as PoolC is supposed to be dynamic I was thinking about creating an additional column (lets call it 'category' for this example) in the first table that changes according to a fieldselection in two Country listboxes.

One sets this category column to 'BMC' for all the entries with the same Country name as Selectionbox number 1. The other one sets all the entries in this category column to 'P' for PoolC for all the Countries that are specified in Selectionbox number 2.

My question now is:

"How can I use selections in listboxes to update this category column?"

I am really stuck here so any help is greatly appreciated!

Thank you!

Re: Updating Table Values after Data Load

petter — Sun, 21 Jan 2018 19:25:40 GMT

I didn't get the logic completely but maybe this can point you in the right direction:

Re: Updating Table Values after Data Load - Qlikview

Anonymous — Tue, 06 Feb 2018 07:59:56 GMT

My bad, I had this thread in Qliksense but I use Qlikview and hence cannot open that file!

Can anyone still help?

topic Re: Updating Table Values after Data Load - Qlikview in QlikView

Updating Table Values after Data Load - Qlikview

Re: Updating Table Values after Data Load

Re: Updating Table Values after Data Load - Qlikview