year expression

[#1]

hi i am new to qlik

i have following expression,  how can i modify that expression for 2016 and 2016 dec

Count (DISTINCT [Real user])

i want two expression

1 for 2016 only ( all data of 2016)

2 for December 2016 ( only data of dec 2016)

Thanks

[sunny_talwar · Accepted solution]

1) Count({<Year = {2016}>} DISTINCT [Real user])

2) Count({<Year = {2016}, Month = {'Dec''}>} DISTINCT [Real user])

[#3]

Count({<Year = {2016}, Month = {'Dec''}>} DISTINCT [Real user])

what what if i want to capture distinct  real user in 2016 whichever months that has higher

[sunny_talwar]

Not sure I follow your question... can you reframe your question?