writing an "AND" statement in qlikview

[#1]

Hi guys,

Please I am trying to write a statement in qlikview as follows:

If month = 'Apr' AND month = 'May' then display these period is spring. But I don't know how to write such  a statement in qlikview. Please any help?

Thanks

[arulsettu]

may be this

if(month='Apr' and month ='May','Spring')

[sunny_talwar]

Do you mean or? If it is Apr or May it is spring?

If(Match(month, 'Apr', 'May'), 'These is Spring', False Statement)

[Chanty4u]

or

=if(month='Apr' or month='May','Spring')

[syukyo_zhu]

Hi,try this

if(month='Apr' OR month ='May','Spring')

[#6]

Hi Sunny,

full I mean AND

Thanks

[sunny_talwar]

Simon how can a month = 'Apr' AND 'may' at the same time? I don't understand what you are trying to do?

[syukyo_zhu]

But how can you have month at the same time is "Apr" and "May"?

Do you have same exemple?

[#9]

Hi Sunny,

Sorry you are right I meant to say if for example EnergytypeID = 53 AND EnergytypeID = 54 then consumption is in spring.

Thanks

[sunny_talwar]

Again its the same issue. If you think of this as a row by row thing. How can a particular row have EnergyTypeID = 53 and 54 at the same time? It can be 53 or 54 but not both, right? or am I missing some details here?