Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
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

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