topic Re: How MaxString works in QlikView

How MaxString works

pascos88 — Wed, 14 Mar 2018 08:34:38 GMT

Hello,

I have a question, I have this expression:

if((Len (trim (maxSTRING({<CampaignYear_Fact = {'2017'}>} ValueReviewed))) <> 0) , maxSTRING({<CampaignYear_Fact = {'2017'}>} ValueReviewed) , 1) --> as column FACT 2017

if((Len (trim (maxSTRING({<CampaignYear_Fact = {'2016'}>} ValueReviewed))) <> 0) , maxSTRING({<CampaignYear_Fact = {'2016'}>} ValueReviewed) , 1) --> as column FACT 2016

and so on for 10 years..

Now since the app is really slow and is not possible to load all the data (cause time of calculation), I am wondering how this Maxstring works. In my expression, the syntax is going to have a cross product with all rows that contain CampaignYear_Fact = 2017,

or qlik recognized that this kind of calculation should be done per rows where for instance the name of the company and the industry is the same?

Someone have idea how I can reduce the time?

I am using a normal table whit this structure:

Industry companyName Fact 2017 Fact2016 Fact2015 ..... Fact2007

Thanks for any help

PS I am using qlik sense

Re: How MaxString works

sunny_talwar — Wed, 14 Mar 2018 08:58:56 GMT

Why don't you create a pivot table where you can add CampaignYear_Fact as a pivoted dimension... Is ValueReviewed a numeric or text field?

Re: How MaxString works

pascos88 — Wed, 14 Mar 2018 09:01:06 GMT

cuold be a text or number

Re: How MaxString works

sunny_talwar — Wed, 14 Mar 2018 09:04:03 GMT

I guess you can still use the similar idea... but use a CampaignYear_Fact as a dimension instead of creating 10 expressions

If(Len(Trim(MaxString({<CampaignYear_Fact = {">=2007<=2017"}>} ValueReviewed))) <> 0, MaxString({<CampaignYear_Fact = {">=2007<=2017"}>} ValueReviewed), 1)

Re: How MaxString works

pascos88 — Wed, 14 Mar 2018 10:10:15 GMT

Sunny Thanks for your answer, your solution giving to me just 1 column.. why? btw is good approach I guess

Re: How MaxString works

sunny_talwar — Wed, 14 Mar 2018 10:59:36 GMT

Did you add CampaignYear_Fact as dimension in a pivot table and then pivoted this dimension to go across instead of going down?

Re: How MaxString works

pascos88 — Wed, 14 Mar 2018 11:07:13 GMT

ok, but without use a Pivot table... I cannot use the same syntax in a simple table?

Re: How MaxString works

sunny_talwar — Wed, 14 Mar 2018 11:09:49 GMT

you can... but then you will see CampaignYear_Fact going down and not across.... I suggest pivot table to get you this

Industry companyName Fact 2017 Fact2016 Fact2015 ..... Fact2007

Without pivot table... you will get this

Industry companyName Year

... ,.... Fact2017

... ,.... Fact2016

... ,.... Fact2015

...

... ,.... Fact2007