Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

greater than value

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?

   

ReNumNameDuration
A13Build1.2
A23Build2.2
A33Build3.5
A43Build4.5
A55Build6.7
A65Build7.6
A75Build8.6
A85Build5.4
A9ARP22.1
A10DRP33.1
A11CRP23.4
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: greater than value

Hi Sony,

Please Check my attach file.

Regards

Miguel del Valle

View solution in original post

21 Replies
Highlighted
Specialist
Specialist

Re: greater than value

Hi Sony,

Check this expression:

=if(

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

[ReNum],

if(

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

[ReNum],

[ReNum]

)

)

Regards

Miguel del Valle

Highlighted
Creator III
Creator III

Re: greater than value

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

Highlighted
Specialist III
Specialist III

Re: greater than value

thanks Miguel,

But it is giving error. syntax .

Highlighted
Specialist III
Specialist III

Re: greater than value

No ravi.

its not wrking it is showing variable syntax is wrong.

Highlighted
Specialist
Specialist

Re: greater than value

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

Highlighted
Specialist III
Specialist III

Re: greater than value

Now expression ok but same result all values are showing.

attaching sample data with out put.

Highlighted
Specialist
Specialist

Re: greater than value

Hi Sony,

Please Check my attach file.

Regards

Miguel del Valle

View solution in original post

Highlighted
Specialist III
Specialist III

Re: greater than value

No Luck Dear

Highlighted
Specialist III
Specialist III

Re: greater than value

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