if-wildmatch-?

Fri, 06 Feb 2015 14:18:44 GMT

Hello everyone and sorry for my bad English . My question is , how do I get to fill a column with the particular values after a check on another column ?

I'll explain:

I have a field MONTH_YEAR format month.year ( 11.2001 ) .

if ( WildMatch ( MONTH_YEAR , '01 . ' or '02 . ' or '03 . ' or '04 . ' ) = 1 , ' Q1 ' ,

if ( WildMatch ( MONTH_YEAR , '05 . ' or '06 . ' or '07 . ' or '08 . ' ) = 1 , ' Q2 ' ,

if ( WildMatch ( MONTH_YEAR , '09 . ' or '10 . ' or '11 . ' or '12 . ' ) = 1 , ' Q3 ' , ) ) ) as Quarter

I would like the column quarter fill values Q1 - Q2 - Q3 after checking the month but I can not do it .

I had thought to divide the field into MONTH_YEAR

Right ( MONTH_YEAR , 4 ) as Year ,

left ( MONTH_YEAR , 2 ) as Month ,

' ' As the Quarter

and then

if ( WildMatch ( Month , '01' or ' 02 ' or ' 03 ' or ' 04 ' ) = 1 , ' Q1 ' ,

if ( WildMatch ( Month , '05 ' or ' 06 ' or ' 07 ' or ' 08 ' ) = 1 , ' Q2 ' ,

if ( WildMatch ( Month , '09 ' or ' 10 ' or ' 11 ' or ' 12 ' ) = 1 , ' Q3 ' , ) ) ) as Quarter

but the result is the same.

how can I do please let advise.

thanks best regards..:)

Re: if-wildmatch-?

giakoum — Fri, 06 Feb 2015 14:21:14 GMT

'Q'&ceil(month(Date#(MONTH_YEAR, 'MM.YYYY'))/3)

Re: if-wildmatch-?

Fri, 06 Feb 2015 14:32:36 GMT

Thanks a lot , I settled with that code that I 've been through.

Re: if-wildmatch-?

giakoum — Fri, 06 Feb 2015 14:35:40 GMT

Not sure what you mean but please close this thread in any case

topic Re: if-wildmatch-? in QlikView

if-wildmatch-?

Re: if-wildmatch-?

Re: if-wildmatch-?

Re: if-wildmatch-?