topic Re: Create Pivot Table without Dimension in QlikView

Create Pivot Table without Dimension

Tue, 25 Feb 2014 08:36:02 GMT

Hi, I want to create a pivot table with 3 column, which is sum(sales_count), sum(Sale_Target), and sum(sales_count)/sum(Sale_Target).

In this case, I don't want any dimension to appear, just the column name.

But the pivot table always show blank dimension. How to hide it?

Regards

Benjamin See

Re: Create Pivot Table without Dimension

er_mohit — Tue, 25 Feb 2014 09:14:37 GMT

here for the dimension purpose which you want to get expression is also write in expression side like this way

Sum(TOTAL{$<Dimension1=,Dimension2= >}sales_count) //for 1 column

Sum(TOTAL{$<Dimension1=,Dimension2= >}Sale_Target) //for 2 column

Sum(TOTAL{$<Dimension1=,Dimension2= >}sales_count)/Sum(TOTAL{$<Dimension1=,Dimension2= >}Sale_Target) //for 3rd column

or without write total you can also do this like

Sum({$<Dimension1=,Dimension2= >}sales_count) //for 1 column

Sum({$<Dimension1=,Dimension2= >}Sale_Target) //for 2 column

Sum({$<Dimension1=,Dimension2= >}sales_count)/Sum(TOTAL{$<Dimension1=,Dimension2= >}Sale_Target) //for 3rd column

Re: Create Pivot Table without Dimension

hic — Tue, 25 Feb 2014 09:22:46 GMT

The pivot table always has a place holder for the dimensions, yes. If you just want a one-liner with these three numbers, I suggest you create a straight table instead. You need to turn the Totals of to make it look nice (Expressions tab).

HIC

Re: Create Pivot Table without Dimension

Tue, 25 Feb 2014 10:01:19 GMT

hI, i had put in the expression, but still it showing the blank dimension (Pivot Table --> Expression -->Definition).

Re: Create Pivot Table without Dimension

Tue, 25 Feb 2014 10:02:09 GMT

Hi, when I use the straight table, even I put in =Sum(), it showing the list of number instead of the total.

Re: Create Pivot Table without Dimension

hic — Tue, 25 Feb 2014 10:05:58 GMT

Then you are using a table box, not a straight table. Create a chart and choose this:

HIC

Re: Create Pivot Table without Dimension

Tue, 25 Feb 2014 10:13:22 GMT

Dear HIC, thank you very much. It work.