Discussion Board for collaboration on QlikView Layout & Visualizations.
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:
What should I do to organize the data so it sums according to the month?
Use MonthStart function in your dimension to achieve monthly amounts.
you can make a chart with
you can add a calculated month field in your script (see above)
month(date) as month,
load * inline