topic Re: Pivot Table Sort Order Help in QlikView

Pivot Table Sort Order Help

haymarketpaul — Thu, 13 Aug 2015 13:55:48 GMT

QV 11 SR4

See attached qvw

With the Industry Type column collapsed it nicely orders in descending User Count - I would like to order the User Count Expression column by descending Industry Type User Count when someone expands a job title.

Re: Pivot Table Sort Order Help

MK_QSL — Thu, 13 Aug 2015 14:09:52 GMT

For job title use below in sort tab as an expression

=IF(Dimensionality() <> 2, Count(DISTINCT UserID))

Re: Pivot Table Sort Order Help

haymarketpaul — Thu, 13 Aug 2015 14:25:22 GMT

Sorry Manish - i'm not sure that helps...

When i expand a job title i then want the industry type user counts in descending count order

Re: Pivot Table Sort Order Help

settu_periasamy — Thu, 13 Aug 2015 14:41:28 GMT

Hi,

Try this.

Enable the Y-value as Descending in Sort by option.

Re: Pivot Table Sort Order Help

haymarketpaul — Thu, 13 Aug 2015 14:50:29 GMT

Perfect - Thank You

Will have to read up on Y Value