Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
DS14
Partner - Contributor III
Partner - Contributor III

How to remove values starts with * for a field in qliksense

Hi Experts,

I have the data in below format.

Field0_Pers.areaField1_Name of EE subgroupMonthValue
* PA00 Field2_Mar-18 No14
* PA0X Field2_Mar-18 No13
* PA01 Field2_Mar-18 No39
* PA02 Field2_Mar-18 No159
* PA03 Field2_Mar-18 No41
* PA05 Field2_Mar-18 No0
* PA06 Field2_Mar-18 No32
* PA07 Field2_Mar-18 No29
* PA08 Field2_Mar-18 No38
* PA09 Field2_Mar-18 No209
* PA10 Field2_Mar-18 No52
* PA12 Field2_Mar-18 No14

 

I need to remove all values for the field Field0_Pers.area  which starts with the *.

Labels (4)
1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Do you want to remove the "*" prefix from the field value:

PurgeChar(Field0_Pers.area, '*')

Or do you want to exclude the records where there is "*" prefix:

LOAD Field0_Pers.area,
....
From ....
Where Left(Field0_Pers.area, 1) <> '*';

 

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

View solution in original post

4 Replies
miskinmaz
Creator III
Creator III

Hi,
You can try PurgeChar ( Field0_Pers.area,'*' )
JordyWegman
Partner - Master
Partner - Master

Hi Deepaksingh,

Is the field always in this condition? If the answer is yes, use the most simplest version: 

Right(Field0_Pers.area,4)

If your field PAXXX varies in length use:

Right(Field0_Pers.area,Len(Field0_Pers.area)-2))

Otherwise use:

KeepChar(Field0_Pers.area,'abcdefghijklmnopqrstuvwxyz1234567890')

Jordy

Climber

 

Work smarter, not harder
jonathandienst
Partner - Champion III
Partner - Champion III

Do you want to remove the "*" prefix from the field value:

PurgeChar(Field0_Pers.area, '*')

Or do you want to exclude the records where there is "*" prefix:

LOAD Field0_Pers.area,
....
From ....
Where Left(Field0_Pers.area, 1) <> '*';

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
DS14
Partner - Contributor III
Partner - Contributor III
Author

Thanks  a  lot Jontydkpi.