Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data value editing

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

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

4 Replies
ogster1974
Partner - Master II
Partner - Master II

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
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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

Not applicable
Author

Thanks a lot jonathan, it worked fine.

Regards,

Pramod