# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Did you mean:
Creator

## above 1000 value

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

8 Replies
MVP

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

or

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

MVP

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

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

MVP

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

MVP

I really wanted it to work

Oh well!!!

MVP

Never mind. Nice trick anyway ...

MVP

Hahahahaha

MVP

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))

MVP

Hi stalwar1,

nice one.

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

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