Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh1216
Creator II
Creator II

How to convert excel script to qlikview script?

Hi

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

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

You can try below script.

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

From Xyz;

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

You can try below script.

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

From Xyz;

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
migueldelval
Specialist
Specialist

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
Creator II
Creator II
Author

thanks

gireesh1216
Creator II
Creator II
Author

thanks

gireesh1216
Creator II
Creator II
Author

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