Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Its is very Simple..
Pl find attched application..
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..
Pl see the expressions in the attched QVW.
I guess you didnt look properly..
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..
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..
Thank You for the response.
I meant my question how do I physcially enter all those 1000 values using inline..in the script editor..
ok..
you can use xls for this..
load data from excel file to Qlikview. That is even better..