Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

You can try below script.

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

From Xyz;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

5 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

You can try below script.

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

From Xyz;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Highlighted
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

Highlighted
Creator II
Creator II

thanks

Highlighted
Creator II
Creator II

thanks

Highlighted
Creator II
Creator II

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