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

Count according monthname in load script

Hi all!     

I have a temp table like:

Date (yyyy-mm-dd), Value

2013-02-03, Red

2013-04-03, White

2013-04-04, White

2013-04-05, White

2014-02-08, White

2014-02-12, White

2014-01-10, White

2014-01-01, White

2014-01-02, White

2014-01-04, White

I need to make a resident load from this table into a new table grouped by MonthName and counting records, like this:

MonthName, Count of records

2013-02, 1

2013-04, 3

2014-01, 4

2014-02, 2

Does anyone know how to do it?

Thanx!!

Pablo

1 Solution

Accepted Solutions
MarcoWedel

QlikCommunity_Thread_140000_Pic1.JPG.jpg

QlikCommunity_Thread_140000_Pic2.JPG.jpg

hope this helps

regards

Marco

View solution in original post

4 Replies
MarcoWedel

tabInput:

LOAD * Inline [

Date, Value

2013-02-03, Red

2013-04-03, White

2013-04-04, White

2013-04-05, White

2014-02-08, White

2014-02-12, White

2014-01-10, White

2014-01-01, White

2014-01-02, White

2014-01-04, White

];

tabOutput:

LOAD Date(MonthName(Date),'YYYY-MM') as MonthName,

     Count(Date) as [Count of records]

Resident tabInput

Group By MonthName(Date);

MarcoWedel

QlikCommunity_Thread_140000_Pic1.JPG.jpg

QlikCommunity_Thread_140000_Pic2.JPG.jpg

hope this helps

regards

Marco

Not applicable
Author

Thanx Marco!

MarcoWedel

You're welcome

regards

Marco