Application Shows Duplicate Months List!

[#1]

Hello all,

Scenario: The application has Months listbox, a year list box. On adding the script for the quarters in a simple tabular structure (listed after the dot) [[[Q1>jan,Feb,Mar;Q1>Apr,May,June....]]], the Months listbox shows duplicate month names on the GUI screen.

LOAD * INLINE [

    Month, Quarter

    Jan, Q1

    Feb, Q1

    Mar, Q1

    Apr, Q2

    May, Q2

    Jun, Q2

    Jul, Q3

    Aug, Q3

    Sep, Q3

    Oct, Q4

    Nov, Q4

    Dec, Q4

];

How do I eliminate duplicate values in Months checklist on the QV document... Somebody?

Thanks,

-Khaled

[#2]

It will be because the format for 'Month' in your data is being seen as distinct from that in your inline table. How is 'Month' defined in your data - month(fieldname) or ?

Can you post an extract of your code?

Regards,

Gordon

[#3]

do this to generate quarters:

mapping Load rowno() as Month,

'Q' & ceil(rowno()/3) as Quarter

AutoGenerate(12);

after that map this in your master calender as:

applymap('quarter_map',num(Month(TempDate)),null()) as Quarter;

regards

vijit

[SunilChauhan · Accepted solution]

Calculate quarter into your script using

'Q' & ceil(rowno()/3)  as Quarter.

[#5]

Hi Gordon,

You are right. I used Typecasting and it worked.

Thanks,

-Khaled

[#6]

Thank you all.

-Khaled