topic Re: if> less in QlikView

if> less

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

Hi There,

I have concern here if the Field>1500 i need to less 10 how can i do that in expression of qlikview?

Regards,

Bing

Anil_Babu_Samineni — Tue, 19 Dec 2017 06:45:24 GMT

Not entirely clear, But

If(Field>1500, If(field<10, Measure))

If(field>1500, Count({<field = {'<10'}>} Measure))

its_anandrjs — Tue, 19 Dec 2017 06:45:30 GMT

What is your expression?

bsbernabe — Tue, 19 Dec 2017 06:48:16 GMT

Disregards this post

Anil Babu and Anand thank you

its_anandrjs — Tue, 19 Dec 2017 06:51:18 GMT

Do some thing this

Ex:-

Expression

if(Field > 1500, Sum(Amount)-10, Sum(Amount) )

devarasu07 — Tue, 19 Dec 2017 06:58:29 GMT

Hi,

like this?

Method 1:

create a calculated measure in your chart object

if(sum(Sales)>1500, sum(Sales)-10, sum(Sales))

Method 2: using back end script method,

Load *, if(Sales>1500, Sales-10, Sales) as [Sales New];

LOAD * INLINE [

Product, Sales

A, 1500

B, 1700

C, 1400

D, 1550

];