Current month of current year

[ishanbansal1204]

Hi Experts,

I have a situation where i have to find out the values for current month of current year , current month of previous year.

for the current year the query was

COUNT(DISTINCT{<MON={'$(=max(MON))'},YR={'$(=max(YR))'}>}ID)

but i am getting the value as 0. Is there anything that i am missing. Please provide your feedback.

[agigliotti]

let's try replacing ' with ".

[qlik4asif]

are you getting values for Max month and Maxyear?

Try to check by placing in Text box

[ishanbansal1204]

I am not getting values for any of the condition. its a zero.

[ishanbansal1204]

I did but Negative. Still the same value.

[qlik4asif]

What is the format of month and year

Try to place Month in list box and

=Max(Month) as expression in Text Object