topic Is there any Tutorial for the Scripts used in QlikView? in QlikView

Is there any Tutorial for the Scripts used in QlikView?

Fri, 17 Jun 2011 04:55:36 GMT

I'm New to QlikView. I just need a Tutorial for the Scripts which are used while loading a database and expressions and etc., ( I'm having the database with one of the columns has individual dates and i want to group them by month while loading the database into qlikview. So i need script for doing this job. )

Is there any Tutorial for the Scripts used in QlikView?

suniljain — Fri, 17 Jun 2011 07:10:09 GMT

I think help available in qlikview tool is enough to learn the scripting in qlikview.

Is there any Tutorial for the Scripts used in QlikView?

kaushiknsolanki — Fri, 17 Jun 2011 07:54:04 GMT

Hi,

I agree with Sunil and i would say go through the community for more help.

Other thing is if you want to get just month out of date field, all you have to do is use month() function. For example

Load

Date,

Month(Date) as Month

From ........

Regards,

Kaushik Solanki

Re: Is there any Tutorial for the Scripts used in QlikView?

Fri, 17 Jun 2011 09:20:11 GMT

Dear Kaushik,

Thanks for the guidance. The given script works well. Thanks a lot and I found the scripts in help menu. I also agree with u people that its enough.

Thanks & Regards,

Dhinakar C.

Re: Is there any Tutorial for the Scripts used in QlikView?

Tue, 04 Sep 2012 06:34:48 GMT

hi kaushik iam new to Qlikview can u provide any material for Qliview scripting

Re: Is there any Tutorial for the Scripts used in QlikView?

Wed, 10 Jul 2013 17:21:16 GMT

how to make monthly report like jan as M1.....DEC as M12,

My script is like this

OrderID,

CustomerID,

EmployeeID,

OrderDate,

Year(OrderDate) as Year,

Month(OrderDate) as Month,

'Q' & Ceil(Month(OrderDate)/3) as Quarter,

Dual('Q' & Ceil(Month(OrderDate)/3) & '-' & Year(OrderDate),

Year(OrderDate) & Ceil(Month(OrderDate)/3)) as QtrYear,

thanks