Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a Straight table with 500+ Dimensions and set of Measures
We use Drag and Drop functionality to Dimensions to create specific set of adhoc reports
Please find the issue faced and analysis performed:
Please find the options enabled and tested but still issue persists
Your table might be corrupt (it's rather seldom but sometimes it happens) or you faced a bug (within releases of QV 11 there were definitely a bug within the tables by more than approximately 40 columns - I don't know in which releases or if it was ever fixed).
Beside this I think that more as 500 dimensions + multiple measures are not really sensible and I'm not surprised that it didn't work stably (you mentioned yourself that there is at least any restriction by 256th column - maybe there are some more because the objects were not designed for this).
I suggest to limit the max. number of dimensions and measures to maybe 20 - and I mean not just limiting the possible number of selected values else that really not more dim/exp columns are created within the object.
- Marcus
I noticed too that sometimes drag and drop in a straight table doesnot work correct.
I try to avoid to mix Dimension and expressions in the table especially when you add or remove column out of a selection box.
If the order cannot be changed I use a macro to reorder the table (happens once in a year)
you only need to change the object id, then create a button with run macro and the table is reordered again
The macro is not written by me (sorry for the guy who wrote it, I donot remember)
Sub ReorderChart
' This Sub may be used, when the order of charts/tables cannot be changed manually
' this is a bug within Qlikview
' running this macro once reorders the charts
' after running, the macro may be deleted
' ToDo:
' copy the macro into macroeditor
' change the objectid CH158 to the objectid of the object which you want to reorder
' create a buttonobject and define action "run macro ReorderChart
' press button and execute macro
' check if chart is in correct order
' delete buttonobject and delete sub within macroeditor
' save your application
'--------------------------------------------------------------------------------------------------------------------------------------
sub ReorderChart
set chart = ActiveDocument.getsheetobject("CH158") ' <-------- change here to your object id
set cp = chart.GetProperties
'get the current sort order
d = cp.TableProperties.DisplayOrder
'msgbox(d)
for i = lbound(d) to ubound(d)
'msgbox d(i) 'for testpurpose only
next
cp.TableProperties.DisplayOrder = 1
chart.setproperties cp
'get the new sort order
d = cp.TableProperties.DisplayOrder
for i = lbound(d) to ubound(d)
'msgbox d(i)
next
end sub
We have developed the application with QV 12.
To add to the issue, we have restricted the max number of fields to be displayed to 152.
The reports would be created with 5 to 10 fields also. So, if we select 5 to 10 fields in position of 1,2,4,6,300,350 (as per the ordering of Dimensions), the Drag and Drop is still not working
This is an adhoc table that uses conditional logic to build/show Dimensions and Expressions? If so, these issues are probably related to the logic you are using. Can you post a qvw?
-Rob
This solution does not work for me.