Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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
21 Replies
migueldelval
Specialist
Specialist

Why?

soniasweety
Master
Master
Author

qlikview I dnt have license . I cant open it.

Anonymous
Not applicable

Hi Sony,

Please use this expression:

if(Name='3Build',
only({<Name={'3Build'},Duration={">=3"}>}ReNum),
if(Name='5Build',
only({<Name={'5Build'},Duration={">=7"}>}ReNum),
ReNum
))

migueldelval
Specialist
Specialist

Ok,

Check this expression:

=if(

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

     [ReNum2],

     if(

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

          [ReNum2],

          IF(

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

          [ReNum2]

)))

And I while make QS file

Regards

Miguel del Valle

soniasweety
Master
Master
Author

I don't know why for my application it is not working

soniasweety
Master
Master
Author

still same result

Anonymous
Not applicable

What is the dimension  you are using??

You should use Duration. Put Name in the list box and select 3 or 5 Build.

tyagishaila
Specialist
Specialist

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

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

Anonymous
Not applicable

balar025
Creator III
Creator III

Hi,

Mymistake, in a expression instead of Renum we need use Duration.

sum({<Duration={'>=$(vDuration)'}>}Duration).



And Q? Do you have separate filter for 3Build and 5Build selection? If no, then it will reduce your data based on selection and then it will give you result.