topic Listbox for date slections in QlikView

Listbox for date slections

Tue, 23 Jun 2009 00:31:23 GMT

I am very new to QlikView

I need to have users make slection on 'Month' and 'Year' based on values from 'sell date'. The report should display all sales based on the selection period. My table doesn't have a separate field for 'Month' and 'Year'.

Should I create a separate table and store the year and Month values? because currently I don't have fields for 'month' and 'year'

Listbox for date slections

johnw — Tue, 23 Jun 2009 00:39:10 GMT

Yes, I would probably create a separate table with the sell date, month and year. These sorts of calendar tables are a very common solution.

Listbox for date slections

Tue, 23 Jun 2009 01:30:43 GMT

Hi Catherine,

you need not modify the original table. All you have to do is use the following syntax on load;

Month (Date Column Name) as Month,

Year (Date Column Name) as Year,

As long as your table is a recognizable date format it shouldn't be a problem. Then you are able to create seperate list boxes using the Month or Year fields.

The best way to learn these little tips and tricks is to look at the examples that QlikView provides you. There are some slick way of handling data in QlikView without modifying your originals.

Listbox for date slections

Tue, 23 Jun 2009 01:46:07 GMT

Thank You. How should I populate the 'Month' and 'Year' columns? The value in the Sell Date column format is '4/1/2008'.

Listbox for date slections

Tue, 23 Jun 2009 01:59:20 GMT

Cat,

Your SellDate format looks fine and QlikView should be able to recognize it. Your load statement for Month and Year should look like something below. QlikView will populate those date fields for you. So when you create the listbox just select the appopriate field for Year or Month. Another tip would be is to uncheck "Single Column" in the list properties under presentation - this way you can resize in a aesthetic manner. 😄


ODBC CONNECT TO [Excel Files;DBQ=C:\DOCUMENTS AND SETTINGS\YSUN\DESKTOP\PRODUCTION.xls];
LOAD SellDate,
 Month (SellDate) as Month,
 Year (SellDate) as Year;
SQL SELECT *
FROM `C:\DOCUMENTS AND SETTINGS\YSUN\DESKTOP\PRODUCTION.xls`.`Sheet1$`;

Listbox for date slections

Tue, 23 Jun 2009 02:03:50 GMT

Thank You !. The example files are not opening up. Is it available on the web?

Listbox for date slections

Tue, 23 Jun 2009 02:14:08 GMT

Cat,

http://demo.qlik.com/ -> you can download as a QlikView file and peruse as your hearts desire.

Also C:\Program Files\QlikView\Examples\Documents has some examples locally. (requires full install)