topic Re: How do i convert SQL SUBSTRING matching numbers logic into QLIKVIEW logic in QlikView

How do i convert SQL SUBSTRING matching numbers logic into QLIKVIEW logic

Wed, 25 Nov 2020 16:16:04 GMT

Dear Expertis,

I'm struggling with one requirement convert into Qlikview from sql logic

]this is my SQL logic where left first number match with numbers like 0,1,2,3,4,5,6,7,8,9 give some coloumn name or else different name .please see the below logic:

Case when SUSTR (ID,1,1) IN ('0','1','2','3','4','5','6','7','8','9') THEN 'ORDID' ELSE ID as derived_order

How do i the same way need to convert into QLikview ?? ,the table values look like below one

11ABC

21XYZ

31cd

ASD

CTR

xtr

nkm

11ABC,21XYZ,31cd }-----> 'ORDID' then 'Non-ORDID'

Please guide me how to acheive this .

Re: How do i convert SQL SUBSTRING matching numbers logic into QLIKVIEW logic

sunny_talwar — Mon, 06 Feb 2017 13:57:59 GMT

May be this

If(IsNum(Left(ID, 1)), 'ORDID', 'Non-ORDID')

Re: How do i convert SQL SUBSTRING matching numbers logic into QLIKVIEW logic

sunny_talwar — Mon, 06 Feb 2017 13:58:57 GMT

Or this:

If(Match(Left(ID, 1), 1, 2, 3, 4, 5, 6, 7, 8, 9, 0), 'ORDID', 'Non-ORDID')

Re: How do i convert SQL SUBSTRING matching numbers logic into QLIKVIEW logic

Mon, 06 Feb 2017 14:07:03 GMT

Brilliant Sunny ,both logics are working

Re: How do i convert SQL SUBSTRING matching numbers logic into QLIKVIEW logic

sunny_talwar — Mon, 06 Feb 2017 14:10:40 GMT

Sweet

Re: How do i convert SQL SUBSTRING matching numbers logic into QLIKVIEW logic

Mon, 06 Feb 2017 14:19:20 GMT

I couldnt find 'CORRECT ANSWER' option ,gudie me where i can find this

Re: How do i convert SQL SUBSTRING matching numbers logic into QLIKVIEW logic

sunny_talwar — Mon, 06 Feb 2017 14:33:58 GMT

This thread was opened as a discussion rather than a question and cannot be marked with a 'Correct Response'. I guess next time you create a new thread, make sure to keep it as a question instead of a discussion (unless it is a discussion that you want to have)

Re: How do i convert SQL SUBSTRING matching numbers logic into QLIKVIEW logic

Tue, 07 Feb 2017 11:31:28 GMT

Hi Sunny ,

I have checked that Box as a Question but unfornately i wouldt get 'Correct Answer Option'

Correct me if i am wrong,if i uncheck the box it would be Discussion Right ?

Regards,

Sunni

Re: How do i convert SQL SUBSTRING matching numbers logic into QLIKVIEW logic

sunny_talwar — Tue, 07 Feb 2017 12:01:08 GMT

Yes, and you can only change between discussion and question in first 15 mins. That window is long gone... so don't worry about it

The only thing I would suggest is that only mark responses which are truly helpful as helpful responses. You marked your own post where you were just acknowledging my responses. How is that going to be helpful for future users visiting this page? The functionality is not just to give points, but to make this community a better place where we can find answer quickly. and this can be only done if all of us play our part well

Best,

Sunny