Table

[#1]

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.

[#2]

Its is very Simple..

Pl find attched application..

[#3]

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..

[#4]

Pl see the expressions in the attched QVW.

I guess you didnt look properly..

[#5]

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..

[#6]

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..

[#7]

Thank You for the response.

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

[#8]

ok..

you can use xls for this..

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