Discussion Board for collaboration on QlikView Scripting.
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:
And I want to display it like this:
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:
But I want to have it summarized.
It would be nice if somebody could halp me with this problem.
Go to Solution.
OrderNumber looks like a dimension to me, not an expression. Try a pivot table with BusinessUnit and OrderNumber as dimensions and =1 as expression.
Hi, ok this works. Now I get this:
But with the column "1" it looks not that nice. Can I hide this?
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.
Perfect, thank you so much.