topic Re: Sorting inside of dimension in QlikView

Sorting inside of dimension

Thu, 25 Jun 2015 11:29:03 GMT

Hi there,

i am using a pivottable like this example:

If i click on A (left side), the selection goes only to dimension A and all of its items (Dimension 2).

Now there's the problem, that i can't sort Cost after the explicit selection of the Dimension 1 (see right side, red numbers).

Any idea how to solve the problem?

Thanks and best regards

Sabrina

swuehl — Thu, 25 Jun 2015 11:35:48 GMT

What are your sort options set in the pivot table?

Have you tried a sort by expression, like

=sum(Cost)

marcus_sommer — Thu, 25 Jun 2015 11:38:18 GMT

- Marcus

Thu, 25 Jun 2015 11:44:54 GMT

Yes, did it.

I have three buttons for three sortings and if i click on it, a variable will filled with the original column name.

In the properties of the table -> sorting -> Dimension theres a sort by expression: =$(vSortierung)

Thu, 25 Jun 2015 11:49:39 GMT

Sorry i think this was my mistake: i want to sort the colum Cost, not dimension 2.

Cost is a formula with a calculation.