greater than value

[soniasweety]

Hi all

I have a data like below

My req is:  I need to get the data when I filter 3build I need only greater than 3days durion Renum should display

and for 5Build  I need to display more than 7Days Renum should display

by default it should display all the data.

below is expression which I used but it is not working.

=if([ Name]='3Build' and [ Duration]>=3,[ReNum])

if([Name]='5Build' and [Duration]>7,[ReNum],[ReNum]))

what is wrong in my exp?

ReNum	Name	Duration
A1	3Build	1.2
A2	3Build	2.2
A3	3Build	3.5
A4	3Build	4.5
A5	5Build	6.7
A6	5Build	7.6
A7	5Build	8.6
A8	5Build	5.4
A9	ARP	22.1
A10	DRP	33.1
A11	CRP	23.4

[migueldelval]

Hi Sony,

Check this expression:

=if(

[Name]='3Build' and [Duration]>=3,

[ReNum],

if(

[Name]='5Build' and [Duration]>7,

[ReNum],

[ReNum]

)

)

Regards

Miguel del Valle

[balar025]

hello,

create variable called

vDuration = if(Name = '3Build',3,if(Name='5Build',8,0)

in expression you can write sum({<Duration={'>=$(vDuration)'}>}Renum)

Thanks

Ravi Balar

[soniasweety]

thanks Miguel,

But it is giving error. syntax .

[soniasweety]

No ravi.

its not wrking it is showing variable syntax is wrong.

[migueldelval]

Could you attach a Data Sample?

And Try with:

=if(

     [Name2]='3Build' and [Duration2]>=3,

     [ReNum2],

     if(

          [Name2]='5Build' and [Duration2]>7,

          [ReNum2],

          IF(

               [Name2]<>'5Build' and [Name2]<>'3Build',

          [ReNum2]

)))

Regards

Miguel del Valle de Gracia

[soniasweety]

Now expression ok but same result all values are showing.

attaching sample data with out put.

[migueldelval · Accepted solution]

Hi Sony,

Please Check my attach file.

Regards

Miguel del Valle

[soniasweety]

No Luck Dear

[soniasweety]

sorry I cant able to open qlikview file ,,am working on qliksense