topic Application Shows Duplicate Months List! in QlikView

Application Shows Duplicate Months List!

Tue, 10 Jan 2012 09:16:13 GMT

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

Application Shows Duplicate Months List!

Tue, 10 Jan 2012 10:13:41 GMT

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

Application Shows Duplicate Months List!

Tue, 10 Jan 2012 11:34:17 GMT

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

Application Shows Duplicate Months List!

SunilChauhan — Tue, 10 Jan 2012 13:50:54 GMT

Calculate quarter into your script using

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

Application Shows Duplicate Months List!

Sat, 14 Jan 2012 06:38:35 GMT

Hi Gordon,

You are right. I used Typecasting and it worked.

Thanks,

-Khaled

Application Shows Duplicate Months List!

Sun, 15 Jan 2012 07:25:20 GMT

Thank you all.

-Khaled