topic Re: Expression does not work in QlikView

Expression does not work

phil_asmar — Fri, 18 Sep 2015 07:02:55 GMT

Dear All,

Why does this not work:

if(

count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2),

EXECUTION_PLANNING_NAME2,EXECUTION_PLANNING_NAME3

)

while this works:

if(

count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2),

1,0

)

PS:EXECUTION_PLANNING_NAME2 AND EXECUTION_PLANNING_NAME3 ARE ATTRIBUTES AND NOT TEXT.

Thank you

Re: Expression does not work

Kushal_Chawda — Fri, 18 Sep 2015 07:06:45 GMT

try

if(

count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2),

EXECUTION_PLANNING_NAME1,EXECUTION_PLANNING_NAME3

)

Re: Expression does not work

Anonymous — Fri, 18 Sep 2015 07:07:56 GMT

what is the Output?

in first Expression EXECUTION_PLANNING_NAME2 might be null and so in a table "-" would be displayed,

while in second Expression "1" would be displayed

WHat do you mean "does not work"

Re: Expression does not work

PrashantSangle — Fri, 18 Sep 2015 07:08:07 GMT

Hi,

what do you want to do with EXECUTION_PLANNING_NAME2,EXECUTION_PLANNING_NAME3

do you want to sum it or count of it

write sum(

if(

count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2),

EXECUTION_PLANNING_NAME2,EXECUTION_PLANNING_NAME3

)

Regards

Re: Expression does not work

phil_asmar — Fri, 18 Sep 2015 07:09:25 GMT

This is a listbox so when i put EXECUTION_PLANNING_NAME2, I WANT IT'S VALUES. I dont want to count or sum. Just the values inside EXECUTION_PLANNING_NAME2 as a list.

Re: Expression does not work

PrashantSangle — Fri, 18 Sep 2015 07:11:24 GMT

Hi,

also check your condition when

Condition count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2) is true

then you are showing EXECUTION_PLANNING_NAME2 which is null

then you will get blank or - .

Regards

Re: Expression does not work

engishfaque — Fri, 18 Sep 2015 07:11:51 GMT

Dear Phil,

Please check this one,

=if(count (Len(Trim(EXECUTION_PLANNING_NAME1)))>0 and EXECUTION_PLANNING_NAME2 = '', EXECUTION_PLANNING_NAME2, EXECUTION_PLANNING_NAME3)

Please note, have you checked values in listed above fields 1, 2, and 3?

Kind regards,

Ishfaque Ahmed

Re: Expression does not work

hic — Fri, 18 Sep 2015 07:16:38 GMT

Your expression contains naked field references, i.e. field references that are not wrapped in aggregation functions. This will cause problems.

See Use Aggregation Functions!

HIC

Re: Expression does not work

phil_asmar — Fri, 18 Sep 2015 07:16:53 GMT

EXECUTION_PLANNING_NAME1 and EXECUTION_PLANNING_NAME2 and EXECUTION_PLANNING_NAME3

all have values and are not null.

At any case, the if statement is either true or false so in any case it should return a dimension.

That is the problem, it is not returning anything!

Re: Expression does not work

phil_asmar — Fri, 18 Sep 2015 07:19:25 GMT

i think that is my problem, but i dont want to use any of the sum or other aggregation functions. I only want to display all the attributes inside the dimension.

How would i do that?

Re: Expression does not work

jonathandienst — Fri, 18 Sep 2015 07:19:43 GMT

If this is a chart expression it probably does not work because the naked field references* have multiple possible values at each row. In this case QV does not know which value to use and returns null (like the Only() function).

You will need to rewrite the expression to avoid the naked fields.

* A field name not enclosed in an aggregation function (like Sum(), Max(), Avg())

Re: Expression does not work

PrashantSangle — Fri, 18 Sep 2015 07:22:17 GMT

Hi,

Can you tell us, your logic with simple words or with example, So that it will become easier to help you

Regards

Re: Expression does not work

phil_asmar — Fri, 18 Sep 2015 07:25:32 GMT

Basically i have a tree (hierarchy) !

EXECUTION_PLANNING_NAME1 is the root and under it the nodes

EXECUTION_PLANNING_NAME2, EXECUTION_PLANNING_NAME3,EXECUTION_PLANNING_NAME4 .....

I want, when a level (example: EXECUTION_PLANNING_NAME1 ) has values, and the next level (EXECUTION_PLANNING_NAME2) does not have values, then i want the EXECUTION_PLANNING_NAME1 because ot would be the last node in the tree that has values(i.e: child node)

I want to list all the nodes (EXECUTION_PLANNING_NAME1 in our example) inside a list box

Re: Expression does not work

phil_asmar — Fri, 18 Sep 2015 07:28:27 GMT

how do you suggest i rewrite the statement to be able to display EXECUTION_PLANNING_NAME1 or EXECUTION_PLANNING_NAME2 in the listbox?

Re: Expression does not work

PrashantSangle — Fri, 18 Sep 2015 07:32:17 GMT

Hi,

In that case you need little modification in your expression.

try below

if(

count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2),

EXECUTION_PLANNING_NAME1,EXECUTION_PLANNING_NAME2

)

Regards

Re: Expression does not work

phil_asmar — Fri, 18 Sep 2015 07:34:38 GMT

Dear Max,

The above still gives an error (it's not about which level im inserting). It's the fact that qlikview isnt displaying the values because of what i have read from other posts which is the naked field.