topic Re: Perform some operation on data based on month level, so create a column “MONTH” using renamed column “DATE”. in QlikView

Perform some operation on data based on month level, so create a column “MONTH” using renamed column “DATE”.

shrayas — Fri, 15 Nov 2024 23:40:04 GMT

I Need to Perform some operation on data based on month level, so create a column “MONTH” using renamed column “DATE” .

LOAD SYMBOL,
SERIES,
OPEN,
HIGH,
LOW,
CLOSE,
LAST,
PREVCLOSE,
TIMESTAMP as Date,
TOTALTRADES,
ISIN,
If(WildMatch(SYMBOL,'AAAAAAA*'), 0, SYMBOL)
FROM
[...........................]
(ooxml, embedded labels);

Re: Perform some operation on data based on month level, so create a column “MONTH” using renamed column “DATE”.

Taoufiq_Zarra — Sun, 08 Nov 2020 09:48:57 GMT

@shrayas if I understood correctly :

...

Month(floor(TIMESTAMP )) as MonthField,

...

and use MonthField after

Re: Perform some operation on data based on month level, so create a column “MONTH” using renamed column “DATE”.

shrayas — Sun, 08 Nov 2020 11:09:44 GMT

Perfect mate thanks!!