Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

sum dimentoin with several conditions

Hi!

I have:

sum(TOTAL{< month={'201210'}, month={'201211'}, Country={'England'}>} Sale)

How can i includ 2 conditions by the same field. in my formula works with only last condition (month={'201211'}) ?

1 Solution

Accepted Solutions
Not applicable

Re: sum dimentoin with several conditions

Try this,

=sum(TOTAL{< month={'201210','201211'},Country={'England'}>} Sale)

4 Replies
mayilvahanan
Not applicable

Re: sum dimentoin with several conditions

Hi

try like this

=sum({<month={'201211','201210'}>}sales)

Hope it helps

Not applicable

Re: sum dimentoin with several conditions

Try this,

=sum(TOTAL{< month={'201210','201211'},Country={'England'}>} Sale)

Not applicable

Re: sum dimentoin with several conditions

yes !!!

thank you

Not applicable

Re: sum dimentoin with several conditions

Thank you