Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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. )

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

5 Replies
suniljain
Master
Master

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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
Author

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

Not applicable
Author

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