Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart (Pivot)Table Dimension Vs. Expression

Hi all,

I really want to  know why it is not possible to display different Expressions in one column that belong to the same dimension in a Chart Table

I have something like this:

BusinessUnitOrderNumber
1-2-31111
1-2-52222
1-2-33333
5-5-51234
1-2-35555

And I want to display it like this:

BusinessUnitOrderNumber
1111
1-2-33333
5555
1-2-52222
5-5-51234

BusinessUnit is my dimension and OrderNumber is my expression.

So maybe I havent understand the difference between dimension and Expression correctly.

If I do this in a TableBox it is nearly working. Because then I get this:

BusinessUnitOrderNumber
1-2-31111
1-2-33333
1-2-35555
1-2-52222
5-5-51234

But I want to have it summarized.

It would be nice if somebody could halp me with this problem.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

OrderNumber looks like a dimension to me, not an expression. Try a pivot table with BusinessUnit and OrderNumber as dimensions and =1 as expression.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

OrderNumber looks like a dimension to me, not an expression. Try a pivot table with BusinessUnit and OrderNumber as dimensions and =1 as expression.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi, ok this works. Now I get this:

2015-07-24_11h03_32.png

But with the column "1" it looks not that nice. Can I hide this?

jonathandienst
Partner - Champion III
Partner - Champion III

No you can't - but the expression is not required for a pivot table. Delete the expression and uncheck the Suppress Nulls option on Properties | Presentation.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Perfect, thank you so much.