topic Re: Table in QlikView

Table

Tue, 12 Feb 2013 16:44:02 GMT

Hi Qlikview gurus,

Below is my requirement, I want to create a table as shown below

	Overall Max	Overall Mean	Overall Min
Sales	100	50	50
Orders	120	60	60
Revenue	1000	500	500

I tried using Pivot table and Straight table but no luck. As you see sales, Orders and Revenue are only labes and I need to show overall max, min and mean of those column.

Any help is highly appreciated.

Re: Table

Tue, 12 Feb 2013 17:41:56 GMT

Its is very Simple..

Pl find attched application..

Re: Table

Tue, 12 Feb 2013 18:11:15 GMT

Hi Kiriti,

I just entered some random values for easy understanding..ideally I can't type constant values..can i put the formula max(sales),min(sales),avg(sales) using inline..

please let me know..

Re: Table

Tue, 12 Feb 2013 18:26:57 GMT

Pl see the expressions in the attched QVW.

I guess you didnt look properly..

Re: Table

Tue, 12 Feb 2013 18:44:10 GMT

Hi Kiriti,

Appreciate your response, but the issue there are 1000 values for Sales..how can I enter all those values and take max,mean and min values.

Thank You..

Re: Table

Tue, 12 Feb 2013 18:49:40 GMT

you can sum up all the values in the expression. Obviously it depends on your criteria..

IF you still dont understand then upload your application, I will get it done for you..

Re: Table

Tue, 12 Feb 2013 18:52:42 GMT

Thank You for the response.

I meant my question how do I physcially enter all those 1000 values using inline..in the script editor..

Re: Table

Tue, 12 Feb 2013 18:56:44 GMT

ok..

you can use xls for this..

load data from excel file to Qlikview. That is even better..