topic Select the minimum value (set analysis) in QlikView

Select the minimum value (set analysis)

Sun, 27 May 2012 14:11:59 GMT

Hello,

In this example, my set analysis works if I do the set analysis based on the ID field.

But why does that not work based on the "Gewicht" field ? Both fields are numeric data.

Do you have an idea ? Thank you!

Select the minimum value (set analysis)

swuehl — Sun, 27 May 2012 23:30:03 GMT

Is your expected result 340?

Try enclosing the dollar sign expansion in the set modifier element list with single quotes:

=sum({$<[Gewicht.]={'$(=min([Gewicht.], 1))'}>} ZE_value)

I think the percentage format of your field is confusing QV here.

Hope this helps,

Stefan

Select the minimum value (set analysis)

Mon, 28 May 2012 21:07:22 GMT

Yes it was the problem thank you. I've also found a solution meanwhile, where I've created a second field in my script, that was: Gewicht * 100 ==> this gives only 10 and not 10%...

In this case the original expression works well... but your solution is by far the best! Thank you so much,

Ivan