how to plot a bar chart by grouping the values on X-axis

[#1]

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]

May be use a calculated dimension

Dimension

SubField(type, '.', -1)

Expression:

Sum(time)

[#3]

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]

Do you mind sharing your app or the above data in an Excel file?

[#5]

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]

Hi,

[#7]

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]

Ganesh - Did you get my private message on the community?

[#9]

hi sunny.. I got your mail id and i sent you the files.. didnt you get it?

[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