if condition

[mshailaja]

Hi all,

i have written if condition in the script ,  while debugging  with 10000  load i am not getting error,  but while i am doing full load i am getting error as invalid expression , Can anyon eplease help where i am going wrong

Thanks

[mshailaja]

Anyoneplease look into it

[tunoi]

try

sum(if(NEW_STATUS='RE',Dur) - sum(if(NEW_STATUS='RE' and WildMatch(NEW_STATUS,'SUPS','OP','CL',), Dur)

[avinashelite]

In order to use the sum you need a Group by clause in your table that is missing

[#5]

hi,

You can use set analysis instead of IF condition.

If condition has to compare with all the records every time when a script is reloaded,so Qlik will hang.

Always prefer set analysis when any filtering is needed.

syntax will be:

sum({<NEW_STATUS = 'RE'>}Dur)-sum({<NEW_STATUS = {'SUSP*','OP*','CL*'}>}Dur)

Regards,

Balakrishnan.R

[#6]

Apologies,

Above logic could be used only in Qlikview objects.

For your question , Follow Avinash suggestion.

Regards,

Balakrishnan.R

[ashok1203]

In Script, If you want use any aggregate function you need to do use the Group By clause.

[mshailaja]

Hi

i have used Group by  in the script, please find the screen shot

while debugging  like limied load 10,000  the script is loading successfulyy, but while reloading  i am getting the error as 'Invalid expression', please help

[tamilarasu]

Hi Sailaja,

Try this,

Group by  PERSID, NEW_STATUS, OLD_STATUS;

All non-aggregated fields must be in a group by clause.

[mshailaja]

Based on PERSID (common key) i am calculating , if i keep Old_status,new_status, as per my undersatanding i wnt get correct data.  can you please help me