Discussion board where members can get started with QlikView.
Another novice question...
I have a spreadsheet with lots of data against DateRaised, so for example
How do I create a list box with Jan, Feb.......Dec, so users can select a month and see the totals
Do I need to do something in the load script? I've been searching other discussions and can't quite work out what I need to do.
Is the data above all in a single field? or multiple?
Either way you just need to add a couple lines to your load script.
month(DateRaised) as month,
year(DateRaised) as year,
If the data is in a single field then do
month(left(DateRaised,8) as month,
I assume you have a load statement in the script like:
You can create a new Month field there by doing something like this:
Month(Date#(DateRaised, 'DD/MM/YY')) as Month
The Date#() function is to properly identify the DateRaised as a date value so that you can use Month() to extract the month.
Ok, but I'm just getting a whole list of month names returned, so
How do make it so it selects all the Januarys?
So I need a list box with
and when a user selects a month it displays all the values for that month
Just add the newly created month field to a list box on the page and it will get you where you want to go!
Ah, sorry about that, try this instead:
Month(Monthstart(Date#(DateRaised, 'DD/MM/YY'))) as Month
This should do the trick hopefully.