topic Re: table with expressions as columns in QlikView

table with expressions as columns

Mon, 29 Aug 2016 13:34:13 GMT

Hello everoybody

I want to build a table which consists of expressions (as columns) and fields from a Data Source (as rows). (Picture)

The First column is calculated via a variable (set_ID):

min({1<ID = {$(=set_ID)}>} [KPI x]

Columns C and D should look like:

max(KPI x)

min({1<ID = {$(=set_ID)}>} [KPI x] – max(KPI x)

… and so on for the following columns.

KPI x shall change, depending of the row.

How can I realize that? I’m not sure where I have to define the rows.

Thank you

Re: table with expressions as columns

Anil_Babu_Samineni — Mon, 29 Aug 2016 15:03:10 GMT

I didn't understand your question. Would you be able to share sample, Expected?

Re: table with expressions as columns

Mon, 29 Aug 2016 15:40:27 GMT

Something like this: (hope you can see the added picture?)

column 1: KPI 1 vas the value "50" for ID=2

column 2: the avg of KPI 1 is 61.5

column 3: and the difference between the value of the selected ID and the avg of KPI 1 is "-11.5".

But now I want to add additional rows, which display the values for KPI 2, KPI 3, KPI 4 and KPI 5.

So that for each KPI there is one row.

Re: table with expressions as columns

sunny_talwar — Mon, 29 Aug 2016 18:05:47 GMT

I would suggest using The Crosstable Load to convert individual KPIs into a field called KPI and then I feel that it would be easier to manipulate using KPI as a dimension