topic Re: Convert table into matrix in QlikView

Convert table into matrix

Tue, 18 Jun 2013 08:28:41 GMT

Hi all,

Appreciate your help here.

My file, source1.csv contains the following fields

Pair = A- B

I would like to display the output in the following format, which is a matrix or grid form.

The content here is sum of the values.

Could i also get a count of the values?

THanks in advance.

AbhijitBansode — Tue, 18 Jun 2013 09:19:25 GMT

Can be achieved using simple pivot table.

See attached.

Regards,

Abhijit

Tue, 18 Jun 2013 11:39:19 GMT

WHen i use pivot table, i got the result in compact form, i,e,

Is there any settings i can do to make it into the matrix form?

Your reply is much appreciated.

Thanks!

AbhijitBansode — Tue, 18 Jun 2013 11:59:38 GMT

for 1st O/P:

Dim: A, B

Measure: Price

for 2nd O/P:

Dim: A, B

Measure: count(Price)

In both pivot tables, drag 2nd dimension B to the top.

Regards,

Abhijit

Wed, 19 Jun 2013 01:38:37 GMT

Exactly what I need! thanks!