Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

sum issue

Hi All,

 

i m using one kpi object  with below expression.

 

 

Labels (4)
1 Solution

Accepted Solutions
MayilVahanan

Hi Sonia,


vMaxDataMonth <-- its store the max month value right? , So it takes the max month value (200).

And also, May and Jul are different Quarter.. In that case, its not satisfy for Quarter also.. 

Hope it helps to understand the issue. 

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

7 Replies
MayilVahanan

Hi Sonia,


vMaxDataMonth <-- its store the max month value right? , So it takes the max month value (200).

And also, May and Jul are different Quarter.. In that case, its not satisfy for Quarter also.. 

Hope it helps to understand the issue. 

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
soniasweety
Master
Master
Author

Hi @MayilVahanan  thanks for the response.

 

in that case i tried select previous quarters but still its showing  max month of selection only..

 

MayilVahanan

Hi

Its depends on the logic in the variable.
Can you pls inform the variable logic?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
soniasweety
Master
Master
Author

currently below screen showing for jul2022.

 

 

MayilVahanan

Its comparing Jul'22 and Jun'22.  If you select multiple month (May & Jul). check the values. 

MayilVahanan_0-1661408815206.png

Hope, it will be same like above.. 

Can you send the sample app with required output?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
soniasweety
Master
Master
Author

yes mayil if i select may &jul its showing same like in expression window.

so what will be the alternate for this?

MayilVahanan

HI

If the user select 2 month, how do you compare with previous month? Any logic behind that?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.