topic Re: Variable in QlikView

Variable

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI ALl,

Can someone explain me what does the below expression does ?

mid(FileName(),34,6) as Year_Month,

Re: Variable

prma7799 — Wed, 21 Jun 2017 09:58:24 GMT

From Qlikview Help

Mid - script and chart function

Mid() returns the part of the input string starting at the position of the character defined by the second argument, 'start', and returning the number of characters defined by the third argument, 'count'. If 'count' is omitted, the rest of the input string is returned. The first character in the input string is numbered 1.

Syntax:

Mid(text, start[, count])

Return data type: string

Arguments:

Argument	Description
text	The original string.
start	Integer defining the position of the first character in text to include.
count	Defines the string length of the output string. If omitted, all characters from the position defined by start are included.

Example	Result
Mid('abcdef',3 )	Returns 'cdef'
Mid('abcdef',3, 2 )	Returns 'cd'

Re: Variable

avinashelite — Wed, 21 Jun 2017 10:03:24 GMT

mid(FileName(),34,6) as Year_Month,

mid() if the function to fetch the values between a range

34 - starting point of the fetching the values

6 - is the length till it should fetch i.e it will fetch the values from 34 to 40

Re: Variable

marcus_malinow — Wed, 21 Jun 2017 10:19:48 GMT

hate to nit-pick

it will retrieve characters 34 to 39 (inclusive)