topic Chart (Pivot)Table Dimension Vs. Expression in QlikView

Chart (Pivot)Table Dimension Vs. Expression

Thu, 23 Jul 2015 15:48:04 GMT

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:

BusinessUnit	OrderNumber
1-2-3	1111
1-2-5	2222
1-2-3	3333
5-5-5	1234
1-2-3	5555

And I want to display it like this:

BusinessUnit	OrderNumber
	1111
1-2-3	3333
	5555
1-2-5	2222
5-5-5	1234

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:

BusinessUnit	OrderNumber
1-2-3	1111
1-2-3	3333
1-2-3	5555
1-2-5	2222
5-5-5	1234

But I want to have it summarized.

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

Re: Chart (Pivot)Table Dimension Vs. Expression

Gysbert_Wassenaar — Fri, 24 Jul 2015 09:02:07 GMT

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

Re: Chart (Pivot)Table Dimension Vs. Expression

Fri, 24 Jul 2015 09:07:38 GMT

Hi, ok this works. Now I get this:

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

Re: Chart (Pivot)Table Dimension Vs. Expression

jonathandienst — Fri, 24 Jul 2015 09:12:55 GMT

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.

Re: Chart (Pivot)Table Dimension Vs. Expression

Fri, 24 Jul 2015 09:16:13 GMT

Perfect, thank you so much.