Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP
MVP

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

View solution in original post

1 Reply
Or
MVP
MVP

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