Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

b_garside
Valued Contributor

Set variable expression via Action using max()

How would I return the Max record ID in this variable expression if the user chooses to go past it?

the last part wont work

=If(vCountryID < max(vCountryID) , '$(vCountryID)'+1 , max(CountryID)  )

2014-02-28_105433.png

1 Solution

Accepted Solutions
b_garside
Valued Contributor

Re: Set variable expression via Action using max()

figured it out. Very much like set analysis.

=If(vCountryID < max(vCountryID) , '$(vCountryID)'+1 , $(=max(CountryID)) )

1 Reply
b_garside
Valued Contributor

Re: Set variable expression via Action using max()

figured it out. Very much like set analysis.

=If(vCountryID < max(vCountryID) , '$(vCountryID)'+1 , $(=max(CountryID)) )

Community Browser