Why does selection box contains so many similar Entries?

[#1]

Hi,

Am new to QV, encounter a situation.

For table Sales

I have import OrderDateKey imported as sales_conv_month and Sales_conv_Yr using Date# function so that i could have Year and Month.

For table Sales converted,

I have did the date# for field SC_year and SC_months to be imported as Sales_conv month and Sales_conv_Yr,

Sales_Conv_month and Sales_conv_Yr in both tables were jointed together synthetically.

When i tried to do a filter on these 2 fields, theres a full range of repetitive values, why is this so?

For e.g if i tried to filter month 07, i should only see 1 entry of Month 07 but instead, i saw loads or it.

Appreciate any help given.

Attached will be my data source and qvw file.

[engishfaque]

Dear Tianhong,

Try this one,

Floor(RepetitiveFieldName) as FieldName

Kind regards,

Ishfaque Ahmed

[simospa]

In your structure you have many circular reference that have to be removed before analyse the file.

Try and then re-send it 🙂

Simon