Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi all
I want to plot a bar chart for the above table. I want the column "type" to be on the x-axis and the time on the y-axis.
But, i would like to group the rows which end with same name(like .php,.js,.css) in column "type".
please ask me , if I am not clear in my exlaination
Thanks
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Ganesh -
Create a new field for file extension in the script like this to make your life easier
SubField([cs-uri-query], '.', -1) as File_Extension
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be use a calculated dimension
Dimension
SubField(type, '.', -1)
Expression:
Sum(time)
 
					
				
		
Hi sunny. i have used it, but I am not getting the appropriate result.
I want x-axs values to be grouped and values should be .css, .php, .js like that // but i am not getting
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Do you mind sharing your app or the above data in an Excel file?
 
					
				
		
Hi sunny
can you please send me your mail id ..
the data is in the form of notepad with spaces, i have converted the data in the tabular format in qlikview.. so i could not send the data in excel file.. but, the table format i have shown above is the exact data that i have... do u know any other functions or expression ,which can group based on the last word string
Thanks
 
					
				
		
 el_aprendiz111
		
			el_aprendiz111
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,

 
					
				
		
Hi Fer
Thanks for the reply
actually, i have the data in my application already , i dont know why to use load inline again.
i just want to plot the data on bar chart
Thanks
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Ganesh - Did you get my private message on the community?
 
					
				
		
hi sunny.. I got your mail id and i sent you the files.. didnt you get it?
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I guess the inline load was intended to create some sample data to demonstrate the SubField() function with.
fer fer could have used your data instead, given you had attached some to your thread instead of posting it in private mails.
hope this helps
regards
Marco
