topic Re: Help on SetAnalysis in QlikView

Help on SetAnalysis

Anonymous — Tue, 16 Oct 2012 07:37:06 GMT

HI,

Please any one can help me to convert this below code into Setanalysis

if( not isnull([Platform]),[ flag] &[Id] ))

Note:- [ flag] &[Id] - Due to this am getting allocated memory exceeded in the chart in QlikView 11

So am thinking that set analysis can help this out.

Regards,

Ankit Modi

Re: Help on SetAnalysis

Jason_Michaelides — Tue, 16 Oct 2012 07:41:38 GMT

I think I'd create a new field based on [ flag] & [Id] in the script. Is that doable?

Jason

Re: Help on SetAnalysis

Anonymous — Tue, 16 Oct 2012 08:03:50 GMT

That could be the last option..

Regards,

Ankit

Re: Help on SetAnalysis

Jason_Michaelides — Tue, 16 Oct 2012 08:06:52 GMT

I would almost always try and push as much logic into the script as possible. Saves on server resources in expressions etc (unless you are creating lots of superfluous data of course!)

Re: Help on SetAnalysis

Gabriel — Thu, 25 Oct 2012 11:39:13 GMT

Hi,

Have you tried

If(([Platform]<>NULL),[ flag] &[Id] ).