Is there any Tutorial for the Scripts used in QlikView?

[#1]

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

[suniljain]

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

[kaushiknsolanki · Accepted solution]

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

[#4]

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.

[#5]

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

[#6]

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