topic expression not giving accurate result on selection in QlikView

expression not giving accurate result on selection

SunilChauhan — Tue, 05 Apr 2011 14:46:12 GMT

hello all,

i am caal calculaating this exp

if(max_Spectral_Efficiency=max_Spectral_efficiency,'Top 1',

if(max_Spectral_Efficiency=max_Spectral_efficiency or max_Spectral_Efficiency=max2_Spectral_efficiency,'Top 2',

if(max_Spectral_Efficiency=max_Spectral_efficiency or max_Spectral_Efficiency=max2_Spectral_efficiency or max3_Spectral_Efficiency=max_Spectral_efficiency,'Top 3')))

showing all values. but when i seleecting one of Top1,Top2,Top3 atleast one is not giving correct result.

its urgent please help me.

thanks

sunil

expression not giving accurate result on selection

suniljain — Tue, 05 Apr 2011 14:49:01 GMT

Check your IF condition.

I think, There should be AND instead of OR in second statement

expression not giving accurate result on selection

Tue, 05 Apr 2011 15:31:38 GMT

Without an example I don't really know for sure, but since it's urgent I'd have to guess that maybe some of your rows are returning multiple values.

For example if:

max_Spectral_Efficiency=max_Spectral_efficiency is true and if

max_Spectral_Efficiency=max2_Spectral_efficiency is true

it would return 'Top 1' and 'Top 3' so it wouldn't return anything

I wasn't sure what exactly "show all values" did so I did a quick test:

LOAD * INLINE [
F1, F2
6, A
6, B
6, C
];

Made a chart to show all values with F1 as dimension and F2 as expression and nothing showed up even though "show all values" was checked, so my guess is that show all values doesn't do what you think it does.

Or I could be completely wrong.

expression not giving accurate result on selection

suniljain — Thu, 07 Apr 2011 15:50:18 GMT

Agree with Jones.

pls correcr if condition so that each statement satisfied only one time.