Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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

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
kaushiknsolanki

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".
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