topic Re. :Re: Problem with PIVOT TABLE in QlikView

Problem with PIVOT TABLE

Mon, 03 Jan 2011 10:02:02 GMT

Hi community.

I have created a table with this statement:

SOLDE:
LOAD GROUPE,
GROUPE_BILAN,
GROUPE_COMPTE
RESIDENT INTER;

I have checked the contents of this table, by displaying the content in a simple table object.

But my problem is that : I want to displays these data in a pivot table.

When i create the pivot table, i select table SOLDE, in a list, i define the properties of pivot table,

the data are not displaying.

I don't know why?

Please i'm waiting for your help.

thanks.

Problem with PIVOT TABLE

deepakk — Mon, 03 Jan 2011 10:25:53 GMT

hi,

You need to add an expression to get value in Pivot table like sum(Amount) or type 1 in expression and check if the values are getting displayed or not.

Re. :Re: Problem with PIVOT TABLE

Mon, 03 Jan 2011 10:52:29 GMT

Thanks DEEPAK

But without an expression, we can't display a pivot table? why?

Re. :Re: Problem with PIVOT TABLE

deepakk — Mon, 03 Jan 2011 10:58:33 GMT

We can only use Table box without expression.

We cant use pivot or straight table without expression because its used for aggregating values based on the added dimensions.

Re. :Re: Problem with PIVOT TABLE

Mon, 03 Jan 2011 11:22:39 GMT

Hi,

As Deepak said We cant use pivot or straight table without expression because its used for aggregating values based on the added dimensions.

But as the Work around or if you are sure that only values are there for dimension then u can use the Min or Max functions.

For ex: if your table is like this

City Count

A 200

B 300

You can use the pivot table expression min(Count) and the dimension as city.

But still you can use the table box itself .

Re. :Re: Problem with PIVOT TABLE

suniljain — Mon, 03 Jan 2011 11:28:36 GMT

The pivot table presents dimensions and expressions in table form. There is no formal limit to the number of dimensions or expressions possible.

A pivot table can be defined without expressions, generating a tree view for navigating the dimension levels.

Re. :Re: Re. :Re: Problem with PIVOT TABLE

Mon, 03 Jan 2011 11:50:07 GMT

But SUNIL, i have created a pivot table without expression.

The data have not shown.

Why???

Re. :Re: Re. :Re: Problem with PIVOT TABLE

suniljain — Mon, 03 Jan 2011 11:54:14 GMT

put any single charater in expression. it will show only pivoting

Re. :Re: Re. :Re: Problem with PIVOT TABLE

Mon, 03 Jan 2011 12:02:08 GMT

Hi,

You can add the expression as 1 or count(1) or any character as sunil said .it will work.

Problem with PIVOT TABLE

Mon, 03 Jan 2011 12:20:47 GMT

HI,

if you are working on Pivot / Straight , it is mandatory to have atleast i measure/ expression.

As sunil and XXX sugessted ,Try this value will come in your table.