topic Re: include if in QlikView

include if

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

Hi all,

I have expression like below but I want to write the if condition in backend how can I write?

this is original expression = Only({$-<compltedate={"*"}>}id)

tried in script if( Only({$-<compltedate={"*"}>},'Yes','No') as NewID

what is wrong in this expression can anyone give suggestions?

Re: include if

Anil_Babu_Samineni — Thu, 14 Sep 2017 04:49:55 GMT

You can not write set analysis in script. Because you are excluding from current selection.. Why are you expecting in script rather we have UI itself.

Re: include if

jonathandienst — Thu, 14 Sep 2017 04:51:16 GMT

Set expressions do not work in script and there is no concept of current selections (the $ in the set expressions) in script. So it is not possible to do what you asked.

I suggest you explain in detail what you are trying to achieve, preferably with some data and the expected output in a sample qvw.

Re: include if

soniasweety — Thu, 14 Sep 2017 04:52:31 GMT

yes anil but,

in my issue there is a table with result giving the values of other table also I want to exclude this in that table

if I use this exp in backend as field I can write easy in front end right so am trying it.

Re: include if

Anil_Babu_Samineni — Thu, 14 Sep 2017 04:53:54 GMT

Even if we need to work on the same expression to next level, of course there is some informative to do. May be explain business as your indeed

Re: include if

prma7799 — Thu, 14 Sep 2017 04:54:54 GMT

for this i guess you can use variable for front end part.

Re: include if

soniasweety — Thu, 14 Sep 2017 04:56:38 GMT

issue is:

I have two tables

in one table to show the values based on the state critical ,

second table should show the date value is null

so I want to exclude this second table result in first table

as first table also giving total two results which I don't want.

Re: include if

soniasweety — Thu, 14 Sep 2017 04:57:08 GMT

how can I use?

Re: include if

soniasweety — Thu, 14 Sep 2017 04:58:32 GMT

or else I can I include the same exp in this

Only({$-<compltedate={"*"}>}id) -----------this into below

=Aggr(only({<Flag1={0},Status-={'passed'}>} if(duration>=Critical,id,null())),id,Name)

Re: include if

Anil_Babu_Samineni — Thu, 14 Sep 2017 04:58:53 GMT

Can you look Exists() and Not Exists() functions in script?

Re: include if

prma7799 — Thu, 14 Sep 2017 05:04:29 GMT

Put value in Variable like

vNewVariable = Only({$-<compltedate={"*"}>}id)

And use in front end like

if( $(vNewVariable ) ,'Yes','No')

Re: include if

soniasweety — Thu, 14 Sep 2017 05:12:52 GMT

not working

after using the variable

giving error when I debug it is showing like this --error ')' expected

Re: include if

prma7799 — Thu, 14 Sep 2017 05:16:17 GMT

Can you please share some sample app.

Re: include if

Chanty4u — Thu, 14 Sep 2017 05:28:37 GMT

or else

try in simple way which field your excluding null use that in same expression like below

=Aggr(only({<Flag1={0},Status-={'passed'}, Completedate-={' '}>} if(duration>=Critical,id,null())),id,Name)

Re: include if

soniasweety — Thu, 14 Sep 2017 05:59:12 GMT

yes chanty it worked thank u