Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
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.
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 a lot jonathan, it worked fine.