Qlik Scripting help

[arusanah]

Hello Qlikers,

 I'm working with survey Data . see attached QVF. My data has first 3 columns . For my analysis I need to create two metrics to find count( highest rating keys) and count( lowest rating keys).

I am trying to create a new column based out of value from 3rd column which I can use in my metric. for that I need to take numeric part from 3rd column(response value) starting with numbers. that from 0-10.

I tried using both Purgechar() and keepchar() . but doesn't seem to get desired result.

Prugechar() - NOTHING CHANGES

KeepChar()- seems to remove characters leaving behind numbers . where as I should be able to see numbers in newly created columns where values are between 0-10 .

e.g row-1 & row-4 should be blank & not 4 . row8 and row 12 should be  blank too. so dees line 14 & 17

Any help is greatly appreciated!

[Nicole-Smith]

I believe this works how you want it to:

If(SubField(ApplyMap('MapSamp',RESPONSEVALUECDWID), ' ', 1) <= 10, SubField(ApplyMap('MapSamp',RESPONSEVALUECDWID), ' ', 1)) AS New_Field

[arusanah]

HI Nicole ,

I had tried this already . This fails for rows where values are  like

298222	3 or more times	3
300038	4 or more sticks	4
298783	5 years or more	5
300943	5 years or more	5
298821	10 or more times	10
301592	10 or more times	10

[Nicole-Smith]

It works when I test it for those values (same calculation as my last post):

[arusanah]

first 3 rows from your screen shot are not ratings that are options for question. so when you do subfield <10 it displays 3 , 4,5 in new column for respective rows .

[Nicole-Smith]

They are showing up because I added extra data for them to show up.  I still stand by that my expression from my previous post will work.  If it isn't working, can you post another QVF files with those values to show me?  Because the new values you mentioned aren't in your example, and I probably added them differently than how they would look in your data.

[arusanah]

hi Nicole,

Please download QVF again.  I replaced it with new version.

Thanks

[Nicole-Smith]

How do you know which values you want to use the numbers from and which ones you don't?  In order to code for it, I need to understand how to differentiate the ones that you want from the ones that should be NULL.