Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Data value editing

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
4 Replies
ogster1974
Honored Contributor II

Re: Data value editing

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

MVP
MVP

Re: Data value editing

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

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

Re: Data value editing

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

Re: Data value editing

Thanks a lot jonathan, it worked fine.

Regards,

Pramod

Community Browser