topic Re: Table distribution in QV in QlikView

Table distribution in QV

Thu, 10 Apr 2014 07:21:16 GMT

Hi, I have a table shown as below.

year	Product	Sale
2011	A	Percentile(A,0.5)
2011	B	Percentile(B,0.5)
2011	C	Percentile(C,0.5)
2009	A	Percentile(A,0.5)
2009	B	Percentile(B,0.5)
2009	C	Percentile(C,0.5)
2008	A	Percentile(A,0.5)

How can i switch it to the table shown like this?

date	A	B	C
2011	Percentile(A,0.5)	Percentile(B,0.5)	Percentile(C,0.5)
2009	Percentile(A,0.5)	Percentile(B,0.5)	Percentile(C,0.5)
2008	Percentile(A,0.5)	Percentile(B,0.5)	Percentile(C,0.5)

Thanks so much!

Re: Table distribution in QV

its_anandrjs — Thu, 10 Apr 2014 07:27:45 GMT

Sorry for response late

Load cross table for the given data but you can use pivot table will be good idea for this

Take a pivot table

Dimension:- year

Dimension:- Product

Expression:- Sale

See the attached snap shot

After adding of the Dimension and Expression Drag a product dimension over the sales expression upper right corner of the chart for pivoting.

Regards

Re: Table distribution in QV

alexandros17 — Thu, 10 Apr 2014 07:29:54 GMT

Here it is

Re: Table distribution in QV

maxgro — Thu, 10 Apr 2014 07:45:02 GMT

you can use a pivot chart with

dimensions year

Product

expression sale

Re: Table distribution in QV

SunilChauhan — Thu, 10 Apr 2014 07:49:40 GMT

use same as Massimo grossi

but Drag Product dimension from vertical to hozonatal at the top of Sale

Thanks

Re: Table distribution in QV

Thu, 10 Apr 2014 07:58:17 GMT

Thanks All!

May be I did not describe my question clearly.

I want to get the median value of sale for the sale column. When I use the pivot table I could not Drag Product dimension from vertical to hozonatal at the top of Sale.

I use the cross table in the script for another table so is there anther method instead of cross table?

Re: Table distribution in QV

alexandros17 — Thu, 10 Apr 2014 08:04:37 GMT

Have you seen my example?

Let me know!

Re: Table distribution in QV

Thu, 10 Apr 2014 08:11:07 GMT

Yes! I have seen your example and I can drag the product in your example. But I could not drag when I put 'Fractile(sale,0.5)' for the Sale column.....

Re: Table distribution in QV

Thu, 10 Apr 2014 09:35:45 GMT

I just copy your example and load my data, it works!!! I don't what happy with my previous one.....

Thanks so much for your help!

Re: Table distribution in QV

alexandros17 — Thu, 10 Apr 2014 09:39:15 GMT

If you want you may mark my answer ...

Re: Table distribution in QV

Mon, 21 Apr 2014 01:18:14 GMT

Hi, another additional question need your help...

How could I remove the 'Product' column? Since I use the pivot table...

Re: Table distribution in QV

alexandros17 — Mon, 21 Apr 2014 07:40:25 GMT

you cannot hide it because you have a pivot ... the only way is to delete it from dimension and for each expression use aggr( ....., Product)