Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
sagaraperera
Creator
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
MK_QSL
MVP
MVP

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

or

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

sunny_talwar

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

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

MarcoWedel

Hi,

other expressions could be:

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

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

one example including other proposed solutions:

QlikCommunity_Thread_256218_Pic1.JPG

QlikCommunity_Thread_256218_Pic2.JPG

maybe you could just use dimension limits instead?

QlikCommunity_Thread_256218_Pic4.JPG

QlikCommunity_Thread_256218_Pic3.JPG

hope this helps

regards

Marco

sunny_talwar

I really wanted it to work

Oh well!!!

MarcoWedel

Never mind. Nice trick anyway ...

sunny_talwar

Hahahahaha

sunny_talwar

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

MarcoWedel

Hi stalwar1,

nice one.

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


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