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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression using variable doesn't work when drill down on chart

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? 

Labels (1)
3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Ummm - it would be useful to have some information:

  • sample qvw including representative data and the relevant chart
  • the chart dimensions and expressions
  • the variable defintion....

Otherwise we are all just guessing...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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.

Not applicable
Author

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.