topic Re: How to convert excel script to qlikview script? in QlikView

How to convert excel script to qlikview script?

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

I TRYING TO CONVERT EXCEL SCRIPT TO QLIKVIEW SCRIPT.

MY EXCEL SCRIPT IS: MONTH([@[Receive Date]] & "-Month"

In Excel Getting Results like this: 1-Month

2-Month

3-Month .

....12-Month

Hear 1-Month is January and 12-Month is December

I want same results in qlikview

kaushiknsolanki — Fri, 11 Nov 2016 10:18:00 GMT

Hi,

You can try below script.

Load Num(Month([Received Date]))&'-Month' as Month

From Xyz;

Regards,

Kaushik Solanki

migueldelval — Fri, 11 Nov 2016 10:19:00 GMT

Hi Gireesh,

Correct expression in QV:

Month([Receive Date])&' -Month'

But if you want to see month name you need to use:

monthname([Receive Date]) as %Month

Regards

Miguel del Valle

gireesh1216 — Fri, 11 Nov 2016 10:30:41 GMT

thanks

gireesh1216 — Fri, 11 Nov 2016 10:30:51 GMT

thanks

gireesh1216 — Fri, 11 Nov 2016 10:48:20 GMT

getting one problem on this expression

I don't have January data but this expression showing garbage data like "-Month"

how to ignore this one