topic Re: variable storing in QlikView

variable storing

soniasweety — Sat, 16 Nov 2024 02:58:55 GMT

Hi all,

@tresB

@sunny_talwar

i have field called Month like that values 201801,20802,201804... like so on..

i want to derive from that field to other format like Jan-19

i want to store this in variable.

Re: variable storing

kaushiknsolanki — Wed, 17 Jul 2019 09:34:14 GMT

Hi Sonia,

You can convert the format using below functions.

Monthname(Date(Date#(Month,'YYYYMM'))) as Newformat.

Once you have this new field, you can use Peek function to get desired value in variable.

Regards,

Kaushik Solanki

Re: variable storing

soniasweety — Wed, 17 Jul 2019 09:57:15 GMT

its giving me null 😞

Re: variable storing

tresB — Thu, 18 Jul 2019 06:39:27 GMT

How should your variable value look like if you have many months in the scope, comma separated? You may try like:

=Concat(Date(Date#(Month,'YYYYMM'),'MMM-YY'), ',')

Re: variable storing

soniasweety — Thu, 18 Jul 2019 06:40:50 GMT

@tresB

No No my field like below

Month

201801

201802

201901

201902

201903

201904 like that

i want to store the format MMM-YY format in variable.. that variable i want to use in stright table expression

Re: variable storing

tresB — Thu, 18 Jul 2019 07:12:25 GMT

The expression I showed above could be used as your variable definition. May be you have to explain a bit more about your expression you want to use variable in.

Re: variable storing

soniasweety — Thu, 18 Jul 2019 08:42:30 GMT

tried this working fine . thanks for your response. @tresB

=DATE(Date#(Max(Month)&'01','YYYYMMDD'),'MMM-YY')

Re: variable storing

durgesh22 — Thu, 18 Jul 2019 08:56:59 GMT

To make it more simple you can use below .

=Date(Date#(Month,'YYYYMM'),'MMM-YY')