topic Re: Charts and Dates in QlikView

Charts and Dates

Thu, 02 Jan 2014 10:54:11 GMT

Hello, I am brand new to QV and I have a question regarding dates and charts. I have a percenage per day for several months. I would like to create a chart that shows the data by day, week and month. I think I want to make a drilldown chart. I have several issues. First in my chart the data is being shown as a number. In my list box I can change the number format to date format but I can't in the chart. Also can I make the drilldown chart for day, month and year with the data recorded by day or would I have to manually add by week and by month? If I can with the data recorded by day, how would I do this?

Re: Charts and Dates

MK_QSL — Thu, 02 Jan 2014 10:59:59 GMT

1) in the script change date dimension as

Date(YourDate) as Date

This will change your date from Numeric to Date format.

Now you can either create the master calender or add below in your script..

Day(YourDate) as Day,

WeekDay(YourDate) as WeekDay,

Month(YourDate) as Month,

Week(YourDate) as Week,

Year(YourDate) as Year

Hope this help.

Re: Charts and Dates

VishalWaghole — Thu, 02 Jan 2014 11:02:56 GMT

Hi Michael,

DrillDown is possible by this way...

Year-->Quarter-->Month-->Week-->Day.

and

you need to explicitly convert your date format at script level like this

Date(Date#([your date field]),'YYYY-MM-DD')

- Regards,

Vishal Waghole

Re: Charts and Dates

jvishnuram — Thu, 02 Jan 2014 11:06:56 GMT

Hi Micheal,

You need to use the date() function to get the format.,

like date(FIELD,'DD-MM-YYYY') in the creation of drill down fields.

Re: Charts and Dates

Thu, 02 Jan 2014 12:21:31 GMT

Where in the scrip do I put that?

Re: Charts and Dates

brijesh1991 — Thu, 02 Jan 2014 12:29:57 GMT

Hi,

use a standard calender and link the calender date with your data model, so that you can have weekly, monthly, quarterly, yearly drilldown on front end.

Also in your dimention tab, you can give Date(yourDateField,'DD/MM/YYYY')

which will format your number into date format