topic Re: Problem with IntervalMatch() function in QlikView

Problem with IntervalMatch() function

Fri, 06 May 2011 11:16:45 GMT

Hi community.

Please i have a problem with a function IntervalMatch().

I would like to adapt this function to match alphabetic

I have attached a sample application that I made.

But I realize that the mapping does not work.

Would you give me an idea to solve this problem?

Best regards.

Problem with IntervalMatch() function

disqr_rm — Fri, 06 May 2011 11:51:06 GMT

Intervalmatch() only works on numeric data. What you can do is assign a numeric value to your data using DUAL() function and then you can use intervalmatch.

Problem with IntervalMatch() function

Fri, 06 May 2011 12:29:36 GMT

Please could you give me an example ...?

Thx

Re: Problem with IntervalMatch() function

disqr_rm — Fri, 06 May 2011 12:34:48 GMT

Idea would be you assign 1-26 to A-Z and z-z, then for each value in your range you convert them to a number. Example: ABC becomes 123. Using LOAD dual('ABC', 123) as Value will give you Value display in Text but it will internally store as 123. Then you should be able to IntervalMatch() on it.

Just an idea for you to take next steps.

OK, I will also try to build one for you.

Re: Problem with IntervalMatch() function

Fri, 06 May 2011 13:29:15 GMT

Thanks sir.

But I do not see the thing without the example

Re: Problem with IntervalMatch() function

Fri, 06 May 2011 14:19:00 GMT

Please are there IntervalMatch function () which does not resume as numerical values?
Thank you.