Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Alarkis
Contributor III
Contributor III

Max Year and Max Month Together in Set analysis giving 0 by default

Max Year and Month in set analysis is giving 0  value until i click on a year..

max year works alone...

Max month works alone but gives wrong results..until i select year.

when i combine them together it gives 0 until i select i year.

count({$<Year={"$(=vCurrentYear)"},MonthNum={'$(=CurrentMonth)'},Source={'Services'}>}APPLICATION_NO)

Variables:

vCurrentYear is =Max(Year)

CurrentMonth is =Max(MonthNum)

 

its giving 

Alarkis_0-1590028355948.png

until i click on a year:

Alarkis_1-1590028401757.png

 

its correct but i want to display Max Year and Max Month value by default..

Thanks.

 

Sample:

Alarkis_0-1590031392728.png

 

iam using Calender and datebrige also.

Labels (3)
8 Replies
Taoufiq_Zarra

@Alarkis 

I can' see anything wrong with the expression except :

count({$<Year={"$(=vCurrentYear)"},Monthnum={'$(=CurrentMonth)'},Source={'Services'}>}APPLICATION_NO)

N->n

if you select and you will get the right results so just check this combination MaxMonth and Maxyear with Source=Services and if Application_no exist with this combinaison

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Alarkis
Contributor III
Contributor III
Author

same issue on all kpis 

i tried both with max not working

n > N was mistype on forum

regards

Taoufiq_Zarra

can you share a sample data ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Alarkis
Contributor III
Contributor III
Author

Sample:

Alarkis_0-1590031392728.png

 

iam using Calender and datebrige also.

Taoufiq_Zarra

and year and MonthNum ?

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Alarkis
Contributor III
Contributor III
Author

from master calander

 

Alarkis_0-1590032124061.png

Alarkis_1-1590032158517.png

 

 

Taoufiq_Zarra

can you try with

=count({<APPLICATION_DATE = {"$(=Date(Max(APPLICATION_DATE)))"},Source={'Services'}>} APPLICATION_NO)

if APPLICATION_DATE is your calendar date

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Alarkis
Contributor III
Contributor III
Author

it didnt work because i had tempdate in calender