topic Re: functions in QlikView

functions

prabhas277 — Wed, 08 Jul 2015 14:43:52 GMT

Hi,

left('7/8/2015',Index('7/8/2015','/',-1)-1) this is my function that output is 7/8 .But my requirement is i want only 8.

how we can achive it?

Re: functions

MK_QSL — Wed, 08 Jul 2015 14:45:22 GMT

=TextBetween('7/8/2015','/','/')

Re: functions

prabhas277 — Wed, 08 Jul 2015 14:45:23 GMT

HI sorry the exact question is

left('7/8/2015',Index('7/8/2015','/',2)-1) this is my function that output is 7/8 .But my requirement is i want only 8.

how we can achive it?

Re: functions

alexandros17 — Wed, 08 Jul 2015 14:46:26 GMT

=Mid('7/8/2015',Index('7/8/2015','/',-1)-1,1)

Re: functions

prabhas277 — Wed, 08 Jul 2015 14:46:47 GMT

hi thanks to sharp reply

by using left and index function how can get it?

Re: functions

veidlburkhard — Wed, 08 Jul 2015 14:48:18 GMT

Hi prabhas

You can use the function Textbetween or Subfield:

In your case Textbetween(Date, '/', '/') = 8

Subfield(Date, '/', 2) = 8

Regards

Burkhard

Re: functions

prabhas277 — Wed, 08 Jul 2015 14:49:32 GMT

by using left and index function how we can get it?

Re: functions

brian_booden — Wed, 08 Jul 2015 14:49:53 GMT

Hi,

How about if it is a string:

Mid('7/8/2015', Index('7/8/2015', 8), 1)

or if the field is a date:

Num(Month(Date('7/8/2015')))

Regards,

Brian

Re: functions

florentina_doga — Wed, 08 Jul 2015 14:50:22 GMT

subfield('7/8/2015','/',1)

Re: functions

alexandros17 — Wed, 08 Jul 2015 15:00:06 GMT

I think it is not possible because left returns the left part of a string strarting from a position ...

Re: functions

prabhas277 — Wed, 08 Jul 2015 15:00:39 GMT

Hi,

my aim is by using left and index function how to achive it? for example

left('7/8/2015',Index('7/8/2015','/',1)-1) for the the o/p is 7

now i want get output is 8 how?

Re: functions

settu_periasamy — Wed, 08 Jul 2015 15:07:26 GMT

Hi prabhas,

just a suggestion.

appreciate your aim.. but if there is easy function to get the result why do you stick on your aiming function?

Re: functions

Digvijay_Singh — Wed, 08 Jul 2015 15:09:13 GMT

As others rightly mentioned, you cannot achieve 8 from left function it seems. as after Index function calculation it becomes left('7/8/2015',3) so it gives first 3 char from left which is 7/8.

Text Between seems to be the perfect solution as it can give you whatever is available between separators '/', should make more business sense although not sure of your actual objective of using this script.

Thanks,

Digvijay

Re: functions

prabhas277 — Wed, 08 Jul 2015 15:17:16 GMT

exactly i am getting output like 7/8..After index function how it becomes left('7/8/2015',3) explain briefly?

Re: functions

Digvijay_Singh — Wed, 08 Jul 2015 15:30:14 GMT

The second parameter Index('7/8/2015','/',2)-1) calculates to 4-1, where 4 is the index of 2nd occurrence of '/'.

Re: functions

MK_QSL — Wed, 08 Jul 2015 17:23:12 GMT

=Mid('7/8/2015',Index('7/8/2015','/',1)+1,Index('7/8/2015','/',2)+1-Index('7/8/2015','/',2))

Re: functions

MK_QSL — Wed, 08 Jul 2015 17:25:12 GMT

=Right(Left('7/8/2015', Index('7/8/2015','/',2)-1),Index('7/8/2015','/',1)-1)

Re: functions

MK_QSL — Wed, 08 Jul 2015 17:26:25 GMT

=Num(Month(Date#('7/8/2015','D/M/YYYY')))