Need help, I'm newbie in qlikview (what is "and" syntax in qlikview expression??)

[#1]

hello, i need help =D

Count ({<Year={2010}>} Sales)

^ use to count sales in 2010

now i want to count sales in 2010 and in Month January,

what is "and" syntax in qlikview expression??

Count ({<Year={2010}>} AND {<Month={January}>} Sales) <<< wrong syntax

help me =p

[#2 · Accepted solution]

Hi,

Try this one:

Count ({<Year={2010}, Month={January}>} Sales)

And see QV help for details.

Good luck!

Rainer

[Miguel_Angel_Baeyens]

Hello,

Use

Count({< Year = {2010}, Month = {'January'} >} Sales)

Check Reference Manual pp. 1307 and onwards.

[#4]

Wow, that's great

Thank you very much Rainer and Miguel,

have a nice day guys