Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with PIVOT TABLE

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.

9 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

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.

Not applicable
Author

Thanks DEEPAK

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

deepakk
Partner - Specialist III
Partner - Specialist III

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.

Not applicable
Author

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 .

suniljain
Master
Master

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.

Not applicable
Author

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

The data have not shown.

Why???

suniljain
Master
Master

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

Not applicable
Author

Hi,

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

Not applicable
Author

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.