topic Re: Pivot Table Not Sorting Correctly in QlikView

Pivot Table Not Sorting Correctly

Wed, 25 Sep 2013 20:33:19 GMT

I can get the straight table to sort correctly on the start date but the pivot table (the one that I want) will not. I've also tried to use the Top field in the expression but still doesn't work. Can someone help with this?

Sort by...

Prospect (A-Z)

Pad (A-Z)

Well (A-Z)

Wellbore (either Start date or Top depth)

Thanks,

Mindy

Re: Pivot Table Not Sorting Correctly

Anonymous — Wed, 25 Sep 2013 20:49:28 GMT

Pivot tables are not "sort-friendly". Looks like you want the "Wellbore" to be sorted differently for each "Well" value, but it does not work this way. It will be sorted consistently the same way for all "Well" values.

Regards,

Michael

Re: Pivot Table Not Sorting Correctly

Thu, 26 Sep 2013 14:10:52 GMT

That's what I figured but had hoped that maybe I was missing something.

Re: Pivot Table Not Sorting Correctly

Thu, 26 Sep 2013 14:25:05 GMT

Found a workaround.....

1st - created a Seq# field in the Wellbore table.

Left Join (Wellbore)
LOAD
idwell as WellboreWellID,
dttmstart as Wellbore_Section_Start_Dttm,
WellboreSeq#;
SQL
SELECT
      idwell,
      dttmstart,
      ROW_NUMBER() OVER (PARTITION BY idwell ORDER BY dttmstart ASC) AS WellboreSeq#
FROM
      wv90.dbo.wvt_wvwellboresize

GROUP BY
idwell,
dttmstart;

2nd - Put Seq# field in front of Wellbore field and "whited out" everything in that field.