Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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.

khan_fayez
Creator
Creator

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

khan_fayez
Creator
Creator

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] )),'|')

khan_fayez
Creator
Creator

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.