topic Re: above 1000 value in QlikView

above 1000 value

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

Dear ALL

I HAVE VALUE EXPRESSION NAME OF GROSSTOT IT HAVE BEEN RS. 1 TO UN LIMITED VALUE BUT I WANT TO GET VALUE ABOVE RS.1000 VALUE. PLEASE HELP ME

I USE GIVEN BELOW

Sum (GROSSTOT)

BUT IT HAVE ALL VALUE , BUT I WANT TO GET VALUE ABOVE RS.1000 VALUE. PLEASE HELP ME

SAGARA

Re: above 1000 value

MK_QSL — Thu, 06 Apr 2017 11:40:22 GMT

SUM(IF(GROSSTOT >= 1000, GROSSTOT))

IF(SUM(GROSSTOT) >= 1000, SUM(GROSSTOT))

Re: above 1000 value

sunny_talwar — Thu, 06 Apr 2017 11:43:54 GMT

First one can be converted to this -> I love making it complicated

Sum(RangeMax(GROSSTOT-1000, 0)+1000)

Re: above 1000 value

MarcoWedel — Thu, 06 Apr 2017 21:51:16 GMT

Hi,

other expressions could be:

Sum({$<GROSSTOT={">=1000"}>} GROSSTOT)

Sum({$<Category={"=Sum(GROSSTOT)>=1000"}>} GROSSTOT)

one example including other proposed solutions:

maybe you could just use dimension limits instead?

hope this helps

regards

Marco

Re: above 1000 value

sunny_talwar — Fri, 07 Apr 2017 00:54:54 GMT

I really wanted it to work

Oh well!!!

Re: above 1000 value

MarcoWedel — Fri, 07 Apr 2017 01:01:37 GMT

Never mind. Nice trick anyway ...

Re: above 1000 value

sunny_talwar — Fri, 07 Apr 2017 07:47:14 GMT

Hahahahaha

Re: above 1000 value

sunny_talwar — Fri, 07 Apr 2017 13:31:56 GMT

marcowedel‌

This one seems to work

Sum(GROSSTOT*RangeMin(Floor(GROSSTOT/1000), 1))

Gives the same result as

Sum({$<GROSSTOT={">=1000"}>} GROSSTOT)

and

SUM(IF(GROSSTOT >= 1000, GROSSTOT))

Re: above 1000 value

MarcoWedel — Fri, 07 Apr 2017 18:16:34 GMT

Hi stalwar1‌,

nice one.

Sum(-(GROSSTOT>=1000)*GROSSTOT)

also should deliver the same result (except for negative GROSSTOTS)