topic GetCurrentField optimization in QlikView

GetCurrentField optimization

vikasgupta — Thu, 06 Jun 2013 08:35:58 GMT

The following script is used as conditional expression in table (10 column) due to this expression sheet is running very slow and some time crash so can any one suggest how can i improve this ? The size of this application is 1.4 GB. means 4 years transaction records.

if(min({1} TOTAL QV_ACCESS_LEVEL) < 3,

if(

GetCurrentField([Sales_Dashboard_Group]) = 'OWNED'

OR GetCurrentField([Sales_Dashboard_Group]) = 'TYPE'

OR GetCurrentField([Sales_Dashboard_Group]) = 'CODE'

OR GetCurrentField([Sales_Dashboard_Group]) = 'NAME'

OR GetCurrentField([Sales_Dashboard_Group]) = 'STATE'

OR GetCurrentField([Sales_Dashboard_Group]) = 'MARKET_NAME',

if(

GetCurrentField([Dashboard-Group]) = 'OWNED'

OR GetCurrentField([Dashboard-Group]) = 'TYPE'

OR GetCurrentField([Dashboard-Group]) = 'CODE'

OR GetCurrentField([Dashboard-Group]) = 'NAME'

OR GetCurrentField([Dashboard_Group]) = 'STATE'

OR GetCurrentField([Dashboard-Group]) = 'MARKET_NAME',

)

Thanks

Vikas

Re: GetCurrentField optimization

Sokkorn — Thu, 06 Jun 2013 08:46:17 GMT

Hi Vikas,

Maybe like this

if(min({1} TOTAL QV_ACCESS_LEVEL) < 3,

if(

Match(GetCurrentField([Sales_Dashboard_Group]),'OWNED','TYPE','CODE','NAME','STATE','MARKET_NAME'),

if(

Match(GetCurrentField([Dashboard-Group]),'OWNED','TYPE','CODE','NAME','STATE','MARKET_NAME'),

)

Regards,

Sokkorn

Re: GetCurrentField optimization

Anonymous — Thu, 06 Jun 2013 10:33:44 GMT

The GetCurrentSelections functions can be turned into variables:

vSalesDashboardGroup = if(Match(GetCurrentField([Sales_Dashboard_Group]),'OWNED','TYPE','CODE','NAME','STATE','MARKET_NAME'),1,0)

vDashboardGroup =

if(Match(GetCurrentField([Dashboard-Group]),'OWNED','TYPE','CODE','NAME','STATE','MARKET_NAME'),1,0)

These can then be used without them needing to be recaculated multiple times:

if(min({1} TOTAL QV_ACCESS_LEVEL) < 3,vSalesDashboardGroup,vDashboard-Group)

Jonathan