Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

writing an "AND" statement in qlikview

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

1 Solution

Accepted Solutions
Not applicable
Author

Sunny,

In plain English what is these expression saying?

View solution in original post

29 Replies
arulsettu
Master III
Master III

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
Champion III
Champion III

or

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

syukyo_zhu
Creator III
Creator III

Hi,try this

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

Not applicable
Author

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
Creator III
Creator III

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

Do you have same exemple?

Not applicable
Author

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?