Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
Not applicable

Break the link during data loading for same field

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:

DateSales
2012/12/05500
2012/12/06600
2012/12/07700
2012/12/08800

Load command as

LOAD Date,

          Date(Date, 'YYYY') as Year,

           Date(Date, 'WWWW') as Day,

          Sales

FROM File.

Result

DateYearDaySales
2012/12/052012Wed500
2012/12/062012Thur600
2012/12/072012Fri700
2012/12/082012Sat800

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

1 Solution

Accepted Solutions
Or
Valued Contributor II

Re: Break the link during data loading for same field

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

1 Reply
Or
Valued Contributor II

Re: Break the link during data loading for same field

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