topic Re: Pivot table with 2 expressions using different dimensions displayed as one row in QlikView

Pivot table with 2 expressions using different dimensions displayed as one row

Anonymous — Wed, 14 Aug 2013 08:05:31 GMT

I have some data about an engineer service call. The call has a time when the customer rang (CallInDate), and a time when the engineer attended(CallCDate) and the type of call.

I have 2 time dimensions for the call. One linked with the CallInDate and one linked with the CallCDate.

I want a table that has month/year in the first column, number of calls taken (CallInDate) as an expression and number of calls completed (CallCDate) in the month.

Obviously I can easily do one or the other by using the appropriate dimension and doing a simple Count(), but how can I get both in the same table?

Re: Pivot table with 2 expressions using different dimensions displayed as one row

Wed, 14 Aug 2013 14:41:22 GMT

George,

see the attached example.

I hope it´s showing what you are looking for.

Good luck!

Rainer

Re: Pivot table with 2 expressions using different dimensions displayed as one row

Anonymous — Thu, 15 Aug 2013 10:42:23 GMT

Hi thanks for the example, the table structure isn't quite what I have though.

I have a fact table, with many different things, one of them is the call data.

They key difference between your example and my data is that the call data, with CallInDate and CallCDate is that there is only one row, containing both dates in different fields.

Re: Pivot table with 2 expressions using different dimensions displayed as one row

Thu, 15 Aug 2013 10:46:32 GMT

George,

please provide some example data (example.qvw).

Thank you!

Rainer

Re: Pivot table with 2 expressions using different dimensions displayed as one row

Anonymous — Thu, 15 Aug 2013 11:39:12 GMT

Hi Rainer,

See attached

Thanks.

Re: Pivot table with 2 expressions using different dimensions displayed as one row

Thu, 15 Aug 2013 17:40:45 GMT

Hi George,

I´m not exactly sure what your starting point is.

I guess the table CallData.

See the attached file.

It´s nearly the same as the first one.

Good luck!

Rainer

Re: Pivot table with 2 expressions using different dimensions displayed as one row

Anonymous — Fri, 16 Aug 2013 07:14:57 GMT

Sorry, yes, the table CallData is the starting point.

Thanks for the help. Is the only way going to be changing my table structure (i.e. doing a resitent as you have)?

The real tables are quite a bit more complex but if this is the only way then I'll have to figure it out.