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

How to organize data by date

I have a set of data that needs to be organized by month. How do I use Qlikview to sort the data accordingly?

For example, in Excel I have data that is organized like this:

1/14/14   2000

2/14/14   3000

2/15/14   3599

3/13/14   4000

4/12/14   5000

4/13/15   6500

What should I do to organize the data so it sums according to the month?

2 Replies
Not applicable
Author

See attached

Use MonthStart function in your dimension to achieve monthly amounts.

maxgro
MVP
MVP

you can make a chart with

dim              month(yourdatefield)

expression    sum(yourvaluefield)

or

you can add a calculated month field in your script (see above)

1.png

source:

load

date,

month(date) as month,

val;

load * inline

[

date, val

1/14/14,  2000

2/14/14,  3000

2/15/14,  3599

3/13/14,  4000

4/12/14,  5000

4/13/15,  6500

]