Data value editing

[#1]

Hi all,

I have data values in my database as 1.1.12 and 1.1.13.

i am using these values as dimension. i want to exclude 1.1. and only 12 and 13 should be printed in x-axis.

Can any one explain how can i achieve this.

i have attached the .qvf file.

Thanks,

Pramod

[ogster1974]

Create a new field in your data load or a master dimension.

=right(fieldname,2) should separate the data for the dimension you need.

Regards

Andy

[jonathandienst · Accepted solution]

Or subfield(fieldname, '.', -1)

[#4]

Hi Andy weir,

Thanks a lot for the reply.

I have a data like 1.1.6 and 1.1.7 like that but when i applied the =right(fieldname,2)  then it's taking .6 and .7.

how can i exclude "."  when i have single value.

same way when i have value 1.1.213 how can i select only 213.

All these must be in one expression.

Thanks,

Pramod

[#5]

Thanks a lot jonathan, it worked fine.

Regards,

Pramod