topic Re: More than and Less than in QlikView

More than and Less than

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

I need to create one column that provides total more than $1.00

Another column when total are negative less than 1.00

Re: More than and Less than

Gabriel — Mon, 16 May 2016 15:38:51 GMT

Hi,

Even though the question is not completely clear, but I will attempt to answer your question.

You probably want to have something in the script like this

Data:

LOAD * INLINE [

ID, Amount

1, 1.2

2, 100

3, 2.1

4, 0.9

5, 0.6

6, 0.7

7, 80

8, 90.5

];

LEFT join (Data)

LOAD

ID,

Amount AS [Less Than 1]

Resident Data

WHERE Amount < 1;

LEFT join (Data)

LOAD

ID,

Amount AS [Greater Than 1]

Resident Data

WHERE Amount > 1;

Re: More than and Less than

trdandamudi — Mon, 16 May 2016 15:41:20 GMT

The question is not clear, can you give some more details...

Re: More than and Less than

Anonymous — Mon, 16 May 2016 16:31:40 GMT

I am entering =A-B I receive a total Amount which is correct. Issue some values are Positive and Some are Negative.

I need two columns - One I want to return all of the Positive Amounts and the 2nd to return all the Negative.

Example calculations in Excel - Trying to produce the same results

=IF(J9-M9<1,J9-M9,0)

=IF(J8-M8>0,J8-M8,0)

Re: More than and Less than

ramoncova06 — Mon, 16 May 2016 16:57:00 GMT

COLUM 1

if(RANGESUM(A-B)) > 0, RANGESUM(A-B))

COLUMN 2

if(RANGESUM(A-B)) < 0, RANGESUM(A-B))

Re: More than and Less than

MarcoWedel — Mon, 16 May 2016 20:18:39 GMT

why is it an issue that some values are positive and others negative?

Re: More than and Less than

MarcoWedel — Mon, 16 May 2016 20:44:58 GMT

an alternative to using two expressions might be a calculated dimension and a single expression:

hope this helps

regards

Marco