List box duplicated values

[#1]

Hi All,

I am learning Qlikview.

I don't know why my list box have duplicated it's values when I have the field is in common between two different table that from two different source.

Following is the code:

[Flight Data]:

LOAD [%Airline ID],

     [%Carrier Group ID] as Carrier_Group_id,

     [%Unique Carrier Code],

     Month,

     [From - To Airport Code],

     [From - To Airport ID],

     [From - To City],

     [From - To State Code],

     [From - To State]

FROM

[..\QVD-File\Data Files\QVDs\Flight Data.qvd]

(qvd)

.. < Other load statements>

LOAD * INLINE [

    Month, MonthNum

    Sep, 6

    Jun, 3

    Oct, 7

    Nov, 8

    Dec, 9

    Jul, 4

    Feb, 11

    Mar, 12

    Apr, 1

    Jan, 10

    May, 2

    Aug, 5

];

The two table are joined automatically by Qlikview using the Month column.

Now when I create a list box with using the Month field I found that the same months appeared twice on the my list.

If I sort it by the load order following is my result following is my result:

Month
Sep
Jun
Oct
Nov
Dec
Jul
Feb
Mar
Apr
Jan
May
Aug
Sep
Jun
Oct
Nov
Dec
Jul
Feb
Mar
Apr
Jan
May
Aug

Also I noticed that the first 12 rows are on the right side while other is on the left side. Is it because they are under different data type? If so, should there be anyway I can fix it?

Thanks for your help!

[MarcoWedel · Accepted solution]

Try loading your Month text values like:

Month(Date#(Month,'MMM')) as Month

or

Dual(Month,Month(Date#(Month,'MMM'))) as Month

hope this helps

regards

Marco

[#3]

Hi Tamil,

Don't know what's happening but it suddenly disappeared. In this three days I have only reinstalled my Virtual Machine and upgraded from Qlikview 11 to Qlikview 12 and recreate the same file and this problem suddenly gone.

Funny!

Elim

[#4]

Hi Tamil,

I know why my problem disappeared now. It is because I have added a left join statement on the inline view by mistake. Once I removed the left join statement, the problem reappeared.

Attached is my qlikview file. Could you please help me to have a look.

The month field is available from two different tables:

[Flight Data]: in the Main Data Sheet

[month_fiscal_year]:: in the Inline sheet.

Thanks in advance!

Kind Regards,

Elim

[#5]

Macro,

Your way work! But do you have any idea why Date#(Month,'MMM') not equal to Month(Date#(Month,'MMM'))?

Thanks!

Elim

[Anonymous]

may be to create the calendar than slove problem