Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Is there any Tutorial for the Scripts used in QlikView?

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

Tags (2)
1 Solution

Accepted Solutions

Is there any Tutorial for the Scripts used in QlikView?

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

5 Replies
suniljain
Honored Contributor

Is there any Tutorial for the Scripts used in QlikView?

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?

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

Not applicable

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

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.

Not applicable

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

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

Not applicable

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

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

Community Browser