topic Set analysis not working when selections are made in QlikView

Set analysis not working when selections are made

Thu, 29 Aug 2013 09:11:13 GMT

I am having a problem that my set analysis is working fine when I dont have a selection made but not working when I am making a selection in Qlikview.

=only({<FinancialYearID={'$(=max(FinancialYearID))'}>}Fiskalår)&chr(10)&'Budget'

The above function works fine. But the below works fine when I have no selection but has no values displayed when I make a selection in Qlikview.

=only({<FinancialYearID={'$(=max(FinancialYearID)-1)'}>}Fiskalår)&chr(10)&'Budget'

I am making a comparison between year where I want to compare the previous year with the year selected. I can not figure out why the function that is not working is not working. Thanks for any help I am completely clueless on this one.

Re: Set analysis not working when selections are made

nilesh_gangurde — Thu, 29 Aug 2013 09:13:58 GMT

Hi,

You need to ignore the selections from the "max(FinancialYearID)".

like if you are selecting Field1 and Field2 then add this max({<Field1=,Field2=>}FinancialYearID).

-Hope this will help.

-Nilesh

Re: Set analysis not working when selections are made

CELAMBARASAN — Thu, 29 Aug 2013 09:47:15 GMT

Hi,

It needs analysis on your data model.

Try with this

only({1<FinancialYearID={'$(=max(FinancialYearID)-1)'}>}Fiskalår)&chr(10)&'Budget'

Note: It ignores all the selections

Re: Set analysis not working when selections are made

jfkinspari — Thu, 29 Aug 2013 09:58:50 GMT

It does depend on whether your Max(FinancialYear) always should show the max value in the data, or it should respect your other selections.

In case it should always result in the max year, you could change the formula to

=only({<FinancialYearID={'$(=max({1}FinancialYearID)-1)'}>}Fiskalår)&chr(10)&'Budget'

Re: Set analysis not working when selections are made

MayilVahanan — Thu, 29 Aug 2013 10:04:06 GMT

Try like this

=only({1<FinancialYearID={'$(=max({1}FinancialYearID)-1)'}>}Fiskalår)

Re: Set analysis not working when selections are made

er_mohit — Thu, 29 Aug 2013 10:11:47 GMT

try this

=only({<FinancialYearID*={'$(=max(FinancialYearID)-1)'}>}Fiskalår)&chr(10)&'Budget'

Re: Set analysis not working when selections are made

Thu, 29 Aug 2013 11:05:21 GMT

Thanks for all the fast answers and input. This is the right answer.

Note: However it does not ignore all selections it takes the max FinancialYearID selected and displays the Fiskalår -1 FinancialYearID. I think that is because the 1 refers to ignore the selection of the values for the Fiscalår field.

Re: Set analysis not working when selections are made

Thu, 29 Aug 2013 11:06:14 GMT

only({1<FinancialYearID={'$(=max(FinancialYearID)-1)'}>}Fiskalår)&chr(10)&'Budget'

Re: Set analysis not working when selections are made

CELAMBARASAN — Thu, 29 Aug 2013 11:18:22 GMT

If you want to ignore selections for the Max(FinancialYearID) then use

Max({1} FinancialYearID)

Hope it helps

Celambarasan

Re: Set analysis not working when selections are made

Thu, 29 Aug 2013 11:26:08 GMT

I want it to not ignore the selection for the Max(FinancialYearID) so the above answer with

"only({1<FinancialYearID={'$(=max(FinancialYearID)-1)'}>}Fiskalår)&chr(10)&'Budget'" works good,