Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm new to QV so this may be an easy question. I have a chart that drills down from geographical territory to region. I am using an expression that includes a variable. The calculation works fine at the top level but returns nothing when I drill down. My variable disappears when I drill down. Does someone know what the issue is?
Ummm - it would be useful to have some information:
Otherwise we are all just guessing...
See attached qvw. When I drill into a region (try region 9) the variable defined in the input box zeroes out. The variable is used in the expressions V% and #Var within the chart at the bottom.
% Var
Num
(Column(1) / Column(2),'#,##0%')-
%Complete
Var%
Num
(Column(1) - Column(2) *%Complete,'#,##0')
Thanks for the reply. I've been traveling but will provide more details today.
I added the qvw file above, and to clarify the issue: the variable used in the iput box % of month complete disappears when I drill down in the chart, causing the V% and #V expressions to also zero out. Any help or advice would be appreciated.