topic Re: Regardsing min(exp) issue in QlikView

Regardsing min(exp) issue

d_koti24 — Fri, 12 Jun 2015 14:35:10 GMT

Hi all,

i Have a field netvalue, that filed contains the values like this :netvalue

my requirement is if i use min(netvalue) ,i am getting 0,but i dont want 0,instead of i want second min value i.e 15.i am writeing this exp in text obj,

please help me on this.

regards,

Re: Regardsing min(exp) issue

swuehl — Fri, 12 Jun 2015 14:36:15 GMT

Try

=min(netvalue, 2)

edit: or if you want the second smallest value only when smallest is zero:

min({<netvalue = {">0"}>} netvalue)

Re: Regardsing min(exp) issue

alexandros17 — Fri, 12 Jun 2015 14:36:26 GMT

Min(netvalue,2) gives you what you need

Re: Regardsing min(exp) issue

rajeshvaswani77 — Fri, 12 Jun 2015 14:40:19 GMT

Hi,

You can try the firstsortedvalue function as well.

thanks,

Rajesh Vaswani

Re: Regardsing min(exp) issue

d_koti24 — Fri, 12 Jun 2015 14:57:40 GMT

Hi,

Thanks for your reply,

But I have a one problem here,i am using this is in text object.i am not selecting any thing it's working perfectly,

if i select any thing it shows second min value.

my req is default i want to display second min value in text objcet instead of showing 0,

if select anything i want to show that min value.if i select 0 i want display 0 in that text box.how to achive this.?

regards,

Re: Regardsing min(exp) issue

swuehl — Fri, 12 Jun 2015 15:09:16 GMT

=if(isnull(GetCurrentSelections()), min(netvalue,2), min(netvalue) )

Re: Regardsing min(exp) issue

d_koti24 — Fri, 12 Jun 2015 15:18:03 GMT

Hi,

It's working fine,Thanks for your reply.

regards,