# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
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?

32 Replies
MVP

Can you try with this

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

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
Specialist

Use this

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

Please specify the quotes inside the curly braces.

Regards

Pratyush

Contributor II
Author

Hi Vikas,

This displays an error

Contributor II
Author

Hi Pratyush

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

Specialist

What is exactly written in your max Month variable?

Regards
Pratyush

Contributor II
Author

=Max(FIN_YR_MTH_NO)

Specialist

Use =date(Max(FIN_YR_MTH_NO))

Regards
Pratyush

Contributor II
Author

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

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)