Discussion Board for collaboration related to QlikView App Development.
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 }-----> 'ORDID' then 'Non-ORDID'
Please guide me how to acheive this .
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)
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 ?
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