I wants to compare two fields using set expression. I used your expression but i am not getting required result its return 1000 instead of 700 so i wants to ask you that we can not use set expression for comparing two fields ?
but if we are using IF condition then its working correct.
plz finds the attached for same and if if any alternative is there then plz let me know .
I don't understand why "1000" is returned. We're comparing fields (Table1.Name and Table2.Name) from separate tables which have no join (i.e. joinless tables -- no line between them in the editor) Since there is no join, maybe the comparison is moot. (Qlikview just does the cartesian product when you mix joinless tables) And since you're summing Table2.Amt, it just checks whether Table2 is filtered at all and accepts that filter...