Applymap with variable in statement possible

Michiel_QV_Fan — Wed, 14 Oct 2009 18:48:40 GMT

Hi,

Created this:

Quarter_table:
MAPPING LOAD * INLINE [
Month, Quarter
Jan, Q1
Feb, Q1
Mrt, Q1
Apr, Q2
May, Q2
Jun, Q2
Jul, Q3
Aug, Q3
Sep, Q3
Oct, Q4
Nov, Q4
Dec, Q4];

and applied it here:

Treat:
NOCONCATENATE LOAD
*,
Month(DATE) as Treatment_month,
Year(DATE) as Treatment_year,
Date(DATE, 'DD-MM_YYYY') as Treatment_Date,
applymap('Quarter_table' , Month(DATE) , 'niks') as Treatment_Quarter
RESIDENT Treat_temp where Year(DATE) >=$($YearFrom);

where the month, year and date work correct but not the month in the applymap. I have no idea why. The applymap result is niks where it should be Q1 or Q2 ....

Please advise

Tnx

Applymap with variable in statement possible

Wed, 14 Oct 2009 18:54:42 GMT

Hi,

could it be that Month(Date) hold the numbers and not the text expression.

So you are trying to compare JAN with 1 as example?

Rainer

Applymap with variable in statement possible

Michiel_QV_Fan — Wed, 14 Oct 2009 19:00:04 GMT

Thanks!

You scored 100%!

topic Applymap with variable in statement possible in QlikView

Applymap with variable in statement possible

Applymap with variable in statement possible

Applymap with variable in statement possible