Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
may be this
if(month='Apr' and month ='May','Spring')
Do you mean or? If it is Apr or May it is spring?
If(Match(month, 'Apr', 'May'), 'These is Spring', False Statement)
or
=if(month='Apr' or month='May','Spring')
Hi,try this
if(month='Apr' OR month ='May','Spring')
Hi Sunny,
full I mean AND
Thanks
Simon how can a month = 'Apr' AND 'may' at the same time? I don't understand what you are trying to do?
But how can you have month at the same time is "Apr" and "May"?
Do you have same exemple?
Hi Sunny,
Sorry you are right I meant to say if for example EnergytypeID = 53 AND EnergytypeID = 54 then consumption is in spring.
Thanks
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?