Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
MVP & Luminary
MVP & Luminary

Re: Chart (Pivot)Table Dimension Vs. Expression

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
4 Replies
MVP & Luminary
MVP & Luminary

Re: Chart (Pivot)Table Dimension Vs. Expression

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

Re: Chart (Pivot)Table Dimension Vs. Expression

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?

MVP
MVP

Re: Chart (Pivot)Table Dimension Vs. Expression

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

Re: Chart (Pivot)Table Dimension Vs. Expression

Perfect, thank you so much.

Community Browser