Break the link during data loading for same field

Thu, 06 Dec 2012 07:27:06 GMT

Hello Expert,

Loading data from one file and want to generate multiple field against same field, the result value set is OK but the duplications values appear in list. For example:

Date	Sales
2012/12/05	500
2012/12/06	600
2012/12/07	700
2012/12/08	800

Load command as

LOAD Date,

Date(Date, 'YYYY') as Year,

Date(Date, 'WWWW') as Day,

Sales

FROM File.

Result

Date	Year	Day	Sales
2012/12/05	2012	Wed	500
2012/12/06	2012	Thur	600
2012/12/07	2012	Fri	700
2012/12/08	2012	Sat	800

In Fields Displayed in Listboxs select all.

The expected Listbox value for 'Year' is only one value '2012'. However, the actual is 4 single value(2012) in the list box. Apparently the year is sticking to original value set. Is there any way to break the link?

Many thanks!

HTC

Re: Break the link during data loading for same field

Or — Thu, 06 Dec 2012 07:50:23 GMT

Try Year(Date) and Weekday(Date) - if memory serves, Date() will just reformat the date but maintain the original value.

topic Break the link during data loading for same field in QlikView

Break the link during data loading for same field

Re: Break the link during data loading for same field