if> less

[bsbernabe]

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]

Not entirely clear, But

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

OR

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

[its_anandrjs]

What is your expression?

[bsbernabe]

Disregards this post

Anil Babu  and Anand thank you

[its_anandrjs]

Do some thing this

Ex:-

Expression

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

[devarasu07]

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

];