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
Specialist

Re: greater than value

Why?

Highlighted
Specialist III
Specialist III

Re: greater than value

qlikview I dnt have license . I cant open it.

Highlighted
Creator
Creator

Re: greater than value

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

Re: greater than value

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

Re: greater than value

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

Highlighted
Specialist III
Specialist III

Re: greater than value

still same result

Highlighted
Creator
Creator

Re: greater than value

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

Re: greater than value

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

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

Highlighted
Creator
Creator

Re: greater than value

Highlighted
Creator III
Creator III

Re: greater than value

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.