topic Re: help with chart please - newbie in QlikView

help with chart please - newbie

Thu, 13 Dec 2012 11:27:43 GMT

hello everyone

have the following fields: these are months from an excel spreadsheet

I am trying to compile a bar chart to show the fluctuation of attendances per month. i think i should be containing these fields into something else like month but i am unsure on how to do this

any guidance would be greatly appreciated

thanks

Re: help with chart please - newbie

sujeetsingh — Thu, 13 Dec 2012 11:40:08 GMT

Hi,

Let Date be your datefield..and Attendence is field with 0 for Absence or 1 for presence

Now while loading..........

Load

Date,

Attendence,

--------new aliase field-----------------

Month(Date) as Month

from...exl....

Now you can use month as Dimension...and Expression=sum(Attendence)

Any other issue let me know.

Re: help with chart please - newbie

Thu, 13 Dec 2012 12:08:32 GMT

Hello

Many Thanks

I would have done as you have mentioned but the data i am using has the following layout (i have removed the figures)

I am thinking the script needs to be changed to categorise all the dates into one field but i am unsure about the correct way to do this?

Thanks

Re: help with chart please - newbie

Thu, 13 Dec 2012 12:51:51 GMT

Load the script using the wizard (when you click on the table files button at the bottom of the edit script box it prompts you to open a file and then opens a wizard) go through the process and choose the enable transformation process option. When you get to the File Wizard option view it gives you the option to put your data into a Crosstable - this will help you to put all the dates into one data field.

Hope this helps