Moving complex expressions in qlikview script

[kishorj1982]

Hi all,

PFA.

Can you please suggest how should i optimize the script.It is taking too much time to open the app in my origional app need to move complex calculations in back end.

I have attached reduced version now

Thanks

[kishorj1982]

Hi all,

Can you please suggest on this.

I want to remove if else in expressions

thanks

[prieper]

MATCH() delivers the position of the result, using MATCH for a flagged field, like

MATCH(MyField, 1)

will deliver either "1", in case that the content of this field is 1 and "0" for all other entries.

So any product calculated will result in either the full amount or in 0.

In the above calculation, where you use nested IFs, see not much possibility, without knowing your data and the background of the calculation.

For better readability would remove the formatting and either do the rounding in the script or in the number-settings.

Peter

[kishorj1982]

Thanks,

what would be the alternative for

if( Dimensionality () <>  0,Round(sum(Total_write_offs_USD)/FX_CONV_RT)/Metric)

For hiding total value in first row for specific column.

Thanks

[prieper]

if "Metric" is a variable, in which you - or the users - may steer the output,

see no alternative.

Peter

[kishorj1982]

shall i use pick match for below.If so please suggest.

if( Dimensionality () <>  0,Round(sum(Total_write_offs_USD)

[prieper]

no - I do not see an advantage in doing so.

edit: spelling

[kishorj1982]

Hi Peter.

I have 1,00,000+ records in my table.

For showing results on access point it is taking too much time.

Please suggest.

Thanks

[prieper]

I can't help further, sorry

Peter