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?
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?