Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi
I have requirement like whenever I select one dimension in the graph that dimension name should pass and display in the title of the graph.
Ex:
Suppose I have a bar graph with drill-down dimension like Region->Brand->Product with Sales as a measure.
My requirement is like whenever user clicks on the any region the should look like "NETSALES BASED ON REGION"
When user drill down to next level it should change to Brand like "NET SALES BASED ON BRAND" instead of Region and same with product.
Please let me know is there any way to achieve this requirement.
 
					
				
		
='NET SALES BASED ON '&getfieldselections(FIELD)
but be aware if they haven't chosen a option in that field it will list all of them
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be you need this:
='NET SALES BASED ON ' & GetCurrentField([Group Name])
Replace [Group Name] with your drill-down group name
 
					
				
		
Hi Mae
Thanks for your reply.
In this case it is not working with Drill down column name. We can't see the hierarchical column in the expression.
 
					
				
		
Hi Sunny,
Thanks for your reply.
When I tried with your expression it is saying not a valid function GetCurrentField.
Even I cant see the drill down column in the expression. Help me out
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Sorry I did not realize that this was Qlik Sense. GetCurrentField() is not available in Qlik Sense yet. How are you creating the drill-down dimension?
 
					
				
		
Am creating as usual. You can find the screenshot for the same.
