Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
gussfish
Creator II
Creator II

WebView duplicates column group headings of Pivot Tables with >1 dim on x axis

Working with

  • QV: QlikView for Windows 10.00.8811.6.SR1
  • OS: Windows XP 2002 SP  2
  • PC: Intel Core2 Duo, P9400 @ 2.4GHz, 3.45 GB
  • Browsers:
    • QlikView IDE internal
    • IE 8.0.6001.18702 (AJAX client)
    • Chrome 11.0.696.68 (AJAX client)

This one's easier to explain via a sample.  In the attached QVW, I have data for a 3-D multiplication table, giving A=X*Y*Z for various values of X, Y and Z.  When I create a pivot table with Y and Z on the horizontal axis, where Y is above Z (as per the 1st two pivot tables in the sample), the values for Y are shown only once on the Y dimension's row i.e. once for each set of Z values.  However, when these are viewed in WebView via any of the above browsers, the values for Y are shown twice - above the leftmost Z value and above the rightmost Z value for each set of Z values!

More generally, this happens for all except the lowest dimension when there are >1 dimensions on the horizontal axis (per the 3rd pivot table in the sample).  It does not occur on the vertical axis (see 4th sample), and is independent of the vertical axis.

Angus.

Labels (4)
0 Replies