topic Re: Customized straight table. in QlikView

Customized straight table.

Mon, 14 Dec 2015 20:49:43 GMT

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

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

sunny_talwar — Mon, 14 Dec 2015 21:06:27 GMT

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

Mon, 14 Dec 2015 21:07:47 GMT

Hi Sunny,

Its Failing to open?

sunny_talwar — Mon, 14 Dec 2015 21:09:05 GMT

Do you have a personal edition of QlikView?

Mon, 14 Dec 2015 21:10:26 GMT

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

sunny_talwar — Mon, 14 Dec 2015 21:13:20 GMT

What is the error message that you are seeing?

Mon, 14 Dec 2015 21:14:38 GMT

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

Mon, 14 Dec 2015 21:21:19 GMT

Can you Share a screenshot.??

sunny_talwar — Mon, 14 Dec 2015 21:24:53 GMT

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:

Mon, 14 Dec 2015 21:49:46 GMT

Thanks Sunny

sunny_talwar — Mon, 14 Dec 2015 21:50:57 GMT

No problem. I am glad I was able to help