Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
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
21 Replies
Highlighted
Specialist
Specialist

Why?

Highlighted
Specialist III
Specialist III

qlikview I dnt have license . I cant open it.

Highlighted
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
))

Highlighted
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

Highlighted
Specialist III
Specialist III

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

Highlighted
Specialist III
Specialist III

still same result

Highlighted
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.

Highlighted
Specialist
Specialist

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

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

Highlighted
Creator
Creator

Highlighted
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.