topic Re: SET ANALYSIS - FORMULA PROBLEMATIC in QlikView

SET ANALYSIS - FORMULA PROBLEMATIC

Wed, 25 Nov 2020 16:16:04 GMT

I am finding the following problematic:

=NUM(SUM({1<MONTH = {'$(vMaxMonth)'}>}Payment), '#,##0.##', '.' , ',')

This formula is still not ignoring my selections.

Please can I ask for advise

Thanks

George

Re: SET ANALYSIS - FORMULA PROBLEMATIC

sunny_talwar — Tue, 25 Oct 2016 17:40:07 GMT

What is your definition for the variable vMaxMonth? Is this an expression? You might need to ignore selection within the expression for this variable

Re: SET ANALYSIS - FORMULA PROBLEMATIC

Tue, 25 Oct 2016 18:01:33 GMT

vMaxMonth==Max(MONTH)

Regrds

Re: SET ANALYSIS - FORMULA PROBLEMATIC

sunny_talwar — Tue, 25 Oct 2016 18:32:21 GMT

Try like this:

vMaxMonth = Max({1} MONTH)

Re: SET ANALYSIS - FORMULA PROBLEMATIC

Tue, 25 Oct 2016 18:40:10 GMT

Thank you , perfect

Re: SET ANALYSIS - FORMULA PROBLEMATIC

Tue, 25 Oct 2016 20:58:45 GMT

had to introduce other time dimensions, QTR and FY.

=sum({<MONTH={'$(vMaxMonth2)'}>}Payment)- Works perfectly

vMaxMonth2 defined as Max({1} MONTH)

But i also need to ensure that QTR and FY selections has no interaction when selected

Been trying the following :MAX({<MONTH = ,FY= ,QTR= >} MONTH) as variable but no result

Re: SET ANALYSIS - FORMULA PROBLEMATIC

sunny_talwar — Tue, 25 Oct 2016 21:03:26 GMT

Max({1} MONTH) won't interact with any selection. 1 within the curly brackets means that don't filter out based on any selection within any field. Are you seeing the results changing based on selection in QTR and FY?

Re: SET ANALYSIS - FORMULA PROBLEMATIC

Wed, 26 Oct 2016 03:37:29 GMT

Yes

Re: SET ANALYSIS - FORMULA PROBLEMATIC

sunny_talwar — Wed, 26 Oct 2016 05:16:24 GMT

Would you be able to share a sample with us to see the issue?

Re: SET ANALYSIS - FORMULA PROBLEMATIC

tresB — Wed, 26 Oct 2016 05:56:50 GMT

Include your set in the Sum() as well like: =sum({<FY, QTR, MONTH={'$(vMaxMonth2)'}>}Payment)

Re: SET ANALYSIS - FORMULA PROBLEMATIC

Anil_Babu_Samineni — Wed, 26 Oct 2016 06:03:01 GMT

Is your issue was resolved, If yes please close this thread by marking Correct Answer

=NUM(SUM({1<MONTH = {'$(=Max(MONTH))'}>}Payment), '#,##0.##')

=Replace(NUM(SUM({1<MONTH = {'$(=Max(MONTH))'}>}Payment), '#,##0.##'), '.' , ',')