Customized straight table.

[#1]

Hi Everyone,

I have a data table similar that is similar to

ID	Year	Status	Tans Time	Wait Time	Cost
1	2015	Arrived	123	545	1
2	2015	Arrived	125	123	1
3	2015	Arrived	324	231	2
4	2015	Arrived	435	133	4
1	2015	Served	234	255	5
3	2015	Served	524	122	3

I want a Table in output similar to

Center	2015
Arrived	4
Served	2
% Served	50%
Avg Tans Time	254
Avg wait Time	300
Cost per trans	2.4

How can achieve this ?? do we have any object that can create customized rows like this??

[sunny_talwar]

There are few ways to do this, one of this is using straight table and 6 expressions:

[#3]

Hi Sunny,

Its Failing to open?

[sunny_talwar]

Do you have a personal edition of QlikView?

[#5]

Yes, I have License but i think it has expired.

[sunny_talwar]

What is the error message that you are seeing?

[#7]

Saying i have reached maximum number of recoveries done using this Personal Edition.

[#8]

Can you Share a screenshot.??

[sunny_talwar · Accepted solution]

No dimension:

6 Expressions:

Exp1: =Count({<Status = {'Arrived'}>} Status)

Exp2: =Count({<Status = {'Served'}>} Status)

Exp3: =Served/Arrived

Exp4: =Avg([Tans Time])

Exp5: =Avg([Wait Time])

Exp6: =Avg(Cost)

Presentation tab -> Horizontal view checked:

[#10]

Thanks Sunny