topic Re: Re: Totals in Table in QlikView

Totals in Table

Fri, 07 Feb 2014 13:06:47 GMT

Hello,

Is it possible to show more totals in a table.

In Chart properties -> Expressions -> Total mode only one.

I wanna see the max, min, average and sum of each range.

Gr,

Ralph

Re: Totals in Table

MK_QSL — Fri, 07 Feb 2014 13:08:34 GMT

If you want to show everything together, you can have New Statistics Box..

Go to empty space and right click and select New Sheet Object

Now Select New Statistics Box and use whatever Fields you want with Available Functions..

Re: Totals in Table

luis_pimentel — Fri, 07 Feb 2014 13:14:39 GMT

I agree with Manish, probably a Statistics box would help you.

Re: Totals in Table

Fri, 07 Feb 2014 13:22:03 GMT

Hello Manish,

Thanks for the quick response.

The answer is good if I have 1 range.

My question was not clear.

I have one straight table with 10 ranges (10 columns; like temperature 1, temperature 2, pressure 1 etc.) and for eache range i want to see the max temp. Min temp. and average temp in the same table.

Re: Totals in Table

Gysbert_Wassenaar — Fri, 07 Feb 2014 13:26:05 GMT

A column can have only one total. If you want to show other totals you need to add more expression columns.

Or perhaps create another table that only shows the totals (min, max and avg) for each of the 10 ranges.

Re: Totals in Table

Fri, 07 Feb 2014 13:31:46 GMT

Goedemiddag Gysbert,

I gonna try it, let you know if it works.

Thanks.

Re: Re: Totals in Table

sunilkumarqv — Fri, 07 Feb 2014 13:38:24 GMT

Please find attached file. Hope this will help to you.

Re: Totals in Table

Anonymous — Fri, 07 Feb 2014 13:45:00 GMT

See attached. Don't ask about a better presentation 🙂