topic Re: Grouping in Pivot table in QlikView

Grouping in Pivot table

Sat, 09 Nov 2013 12:14:32 GMT

Hello,

Is there any way for grouping "unit of price" in a pivot table .(Example)

with Scale in 10000 unit.

unit of price :

0 to 10000

10001 to 20000

20001 to 30000

30001 to 40000

.....

..... to 13395000

Anonymous — Sat, 09 Nov 2013 12:22:01 GMT

Saeed

Try adding a Calculated Dimension of :

=round(DastyarSale_Data.Fe, 10000)

You probably want to sort by it as well.

Best Regards, Bill

Sat, 09 Nov 2013 12:24:56 GMT

YEs.

try to create in lo ad script a new dimension as:

....

load

unitprice,

if(unitprice>0 and unitprice<10000, 'group1',

if(unitprice>10001 and unitprice<20000, 'group2',

if(unitprice>20001 and unitprice<30000, 'group3'))) as Grouping,

....

So Grouping is a dimension for use in presentation.

REgards

MArio

swuehl — Sat, 09 Nov 2013 12:25:16 GMT

You can use a calculated dimension with the class() function (or create an additional field in your load script using the same function).

Sat, 09 Nov 2013 12:42:15 GMT

Thanks Friends.