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: 
bimanbeginner
Contributor II
Contributor II

Variable in Set Analysis

Hi There

I am trying to calculate a percentage out of two formulas, The set analysis doesn't seem to be working with the variable please assist.

vMTDCALC = =


(
Sum({<Survey={'Survey1'}>}Excellent)/(Sum({<Survey={'Survey1'}>}Poor)+Sum({<Survey={'Survey1'}>}Average)+Sum({<Survey={'Survey1'}>}Excellent))*0.70

+

Sum({<Survey={'Survey2'}>}Excellent)/(Sum({<Survey={'Survey2'}>}Poor)+Sum({<Survey={'Survey2'}>}Average)+Sum({<Survey={'Survey2'}>}Excellent))*0.30)

In my text box I have

=Sum({<FIN_YR_MTH_NO={$(vMaxFinYrMthNo)}>}$(vMTDCALC))

The Calculation of sum(vMTDCALC) works but it seems to be ignoring my set analysis... it doesn't look at the max year at all, do I need to some how use the Aggrr function?

Your assistance is appreciated.

32 Replies
vikasmahajan

Can you try with this

=Sum({<FIN_YR_MTH_NO={$(vMaxFinYrMthNo)}>}  (=$(vMTDCALC)) )

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
prat1507
Specialist
Specialist

Use this

=Sum({<FIN_YR_MTH_NO={'$(vMaxFinYrMthNo)'}>}$(vMTDCALC))


Please specify the quotes inside the curly braces.


Regards

Pratyush

bimanbeginner
Contributor II
Contributor II
Author

Hi Vikas,

This displays an error

bimanbeginner
Contributor II
Contributor II
Author

Hi Pratyush

The max date variable is being ignored here too...

prat1507
Specialist
Specialist

What is exactly written in your max Month variable?


Regards
Pratyush

bimanbeginner
Contributor II
Contributor II
Author

=Max(FIN_YR_MTH_NO)

prat1507
Specialist
Specialist

Use =date(Max(FIN_YR_MTH_NO))


Regards
Pratyush

bimanbeginner
Contributor II
Contributor II
Author

This will break the variable, The current variable is working correctly...

prat1507
Specialist
Specialist

Store your variable  vMTDCALC  without '='

vMTDCALC

(
Sum({<Survey={'Survey1'}>}Excellent)/(Sum({<Survey={'Survey1'}>}Poor)+Sum({<Survey={'Survey1'}>}Average)+Sum({<Survey={'Survey1'}>}Excellent))*0.70

+

Sum({<Survey={'Survey2'}>}Excellent)/(Sum({<Survey={'Survey2'}>}Poor)+Sum({<Survey={'Survey2'}>}Average)+Sum({<Survey={'Survey2'}>}Excellent))*0.30)

and then use your expression.