topic Re: greater than value in QlikView

greater than value

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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?

ReNum	Name	Duration
A1	3Build	1.2
A2	3Build	2.2
A3	3Build	3.5
A4	3Build	4.5
A5	5Build	6.7
A6	5Build	7.6
A7	5Build	8.6
A8	5Build	5.4
A9	ARP	22.1
A10	DRP	33.1
A11	CRP	23.4

Re: greater than value

migueldelval — Tue, 04 Jul 2017 09:56:14 GMT

Hi Sony,

Check this expression:

=if(

[Name]='3Build' and [Duration]>=3,

[ReNum],

if(

[Name]='5Build' and [Duration]>7,

[ReNum],

[ReNum]

)

Regards

Miguel del Valle

Re: greater than value

balar025 — Tue, 04 Jul 2017 09:56:35 GMT

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

Re: greater than value

soniasweety — Tue, 04 Jul 2017 10:00:52 GMT

thanks Miguel,

But it is giving error. syntax .

Re: greater than value

soniasweety — Tue, 04 Jul 2017 10:04:19 GMT

No ravi.

its not wrking it is showing variable syntax is wrong.

Re: greater than value

migueldelval — Tue, 04 Jul 2017 10:07:19 GMT

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

Re: greater than value

soniasweety — Tue, 04 Jul 2017 10:14:14 GMT

Now expression ok but same result all values are showing.

attaching sample data with out put.

Re: greater than value

migueldelval — Tue, 04 Jul 2017 10:16:02 GMT

Hi Sony,

Please Check my attach file.

Regards

Miguel del Valle

Re: greater than value

soniasweety — Tue, 04 Jul 2017 10:16:55 GMT

No Luck Dear

Re: greater than value

soniasweety — Tue, 04 Jul 2017 10:17:52 GMT

sorry I cant able to open qlikview file ,,am working on qliksense

Re: greater than value

migueldelval — Tue, 04 Jul 2017 10:19:16 GMT

Why?

Re: greater than value

soniasweety — Tue, 04 Jul 2017 10:20:53 GMT

qlikview I dnt have license . I cant open it.

Re: greater than value

Anonymous — Tue, 04 Jul 2017 10:21:51 GMT

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

Re: greater than value

migueldelval — Tue, 04 Jul 2017 10:22:37 GMT

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

Re: greater than value

soniasweety — Tue, 04 Jul 2017 10:29:02 GMT

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

Re: greater than value

soniasweety — Tue, 04 Jul 2017 10:33:25 GMT

still same result

Re: greater than value

Anonymous — Tue, 04 Jul 2017 10:36:08 GMT

What is the dimension you are using??

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

Re: greater than value

tyagishaila — Tue, 04 Jul 2017 10:36:56 GMT

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

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

Re: greater than value

Anonymous — Tue, 04 Jul 2017 10:38:47 GMT

Re: greater than value

balar025 — Tue, 04 Jul 2017 11:00:23 GMT

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.