How to build a summary table?

Mon, 28 Feb 2011 09:43:42 GMT

My target is to build something similar to a statistic box, but

- with indicators based on several field

- with different set of selection

My table would have 2 columns [Statistic label] and [Statistic value]

For example:

Number of incidents for current month | Value

Number of incidents for previous month | Value

%Increase (m/m-1) | Value

Number of incident YTD | Value

Resolution time (hours) | Value

....

Each cell of the 2column should have its own expression (made of 'Set Analysis').

For the moment, I import the definition of my statistics, coming from an Excel file. And with a macro, I would like to process the 2nd expression which contains the expression (in text) in order to retrieve the real value

I wanted to used a TableBox with the method SetInputFieldCell, but it does not seem to accept expression.

Another idea, would be to process the expression within the macro, and paste the value inside the TableBox (But i think it is not that clean)

Any better idea?

How to build a summary table?

Tue, 01 Mar 2011 04:22:16 GMT

You might tell me to use a pivot table and put enter all my expressions. But they will be displayed as columns. Is there any ways to transpose it? So my columns becomes rows?

Thanks in advance,

How to build a summary table?

Wed, 02 Mar 2011 09:09:37 GMT

topic closed.

Chart properties > Presentation > Allow Pivoting

topic How to build a summary table? in QlikView

How to build a summary table?

How to build a summary table?

How to build a summary table?