Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Or subfield(fieldname, '.', -1)
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
Or subfield(fieldname, '.', -1)
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
Thanks a lot jonathan, it worked fine.
Regards,
Pramod