topic Re: How to organize data by date in QlikView

How to organize data by date

Fri, 04 Apr 2014 19:11:29 GMT

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?

Fri, 04 Apr 2014 19:20:52 GMT

See attached

Use MonthStart function in your dimension to achieve monthly amounts.

maxgro — Fri, 04 Apr 2014 19:25:10 GMT

you can make a chart with

dim month(yourdatefield)

expression sum(yourvaluefield)

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

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

]