topic error in sintax qs in QlikView

error in sintax qs

pascos88 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys what is wrong with this?

= MaxString({<CampaignYear_Fact = {$(CampaignYear_Fact)-1}>} ValueReviewed)

I would have the ValueReviewed value of the last year. So CampaignYear_Fact -1.

Thanks a lot

Re: error in sintax qs

MK_QSL — Thu, 05 Apr 2018 09:51:11 GMT

may be try

=MaxString({<CampaignYear_Fact = {"$(=Max(CampaignYear_Fact)-1)"}>}ValueReviewed)

Re: error in sintax qs

avinashelite — Thu, 05 Apr 2018 09:55:12 GMT

$(CampaignYear_Fact)- is referring to variable or field ..if its field the your syntax is wrong

follow Manish approach

Re: error in sintax qs

pascos88 — Thu, 05 Apr 2018 09:56:33 GMT

it is a field... How I should write it?

Re: error in sintax qs

avinashelite — Thu, 05 Apr 2018 10:57:43 GMT

Follow Manish approach that should work

=MaxString({<CampaignYear_Fact = {"$(=Max(CampaignYear_Fact)-1)"}>}ValueReviewed)

Re: error in sintax qs

pascos88 — Thu, 05 Apr 2018 11:08:17 GMT

doesn't works, still in the table I got Invalid dimension. CampaignYear_Fact is a field, and I would have info about ValueReviewed but last years, than something like CampaignYear_Fact- 1

Re: error in sintax qs

avinashelite — Thu, 05 Apr 2018 11:11:37 GMT

Your trying this in the dimension ?? try like this then

=Aggr(MaxString({<CampaignYear_Fact = {"$(=Max(CampaignYear_Fact)-1)"}>}ValueReviewed),dimesion)

Re: error in sintax qs

pascos88 — Thu, 05 Apr 2018 11:11:57 GMT

unfortunately doesn't....

Re: error in sintax qs

chinnuchinni — Thu, 05 Apr 2018 11:12:40 GMT

CampaignYear_Fact is in year foamat or date_format ?

if it is in date format,use the below:

=MaxString({<CampaignYear_Fact = {"$(=Max(Year(CampaignYear_Fact))-1)"}>}ValueReviewed)

Re: error in sintax qs

pascos88 — Thu, 05 Apr 2018 11:32:00 GMT

it is already in year, with this formula I get an Invalid dimension, even if the script in the table looks good. I mean onche I write the set expression, there is no error..

Re: error in sintax qs

avinashelite — Thu, 05 Apr 2018 11:58:31 GMT

Did you tried this

=Aggr(MaxString({<CampaignYear_Fact = {"$(=Max(CampaignYear_Fact)-1)"}>}ValueReviewed),dimesion)

if it still does not work then please share the sample app