topic Re: Element Function with dual field in QlikView

Element Function with dual field

bgerchikov — Tue, 23 Sep 2014 17:48:01 GMT

Hello,

Has anybody used Element Functions for dual fields with text values?

For example, Sum( ${<Field1=P(Field2)>} Amount) whereas both Field1 and Field2 are dual - doesn't work.

Instead:

Sum(${<Field1={"Value2"}>} Amount) - does work

Sum(${<Field1={$(='"'& concat(Field2,'","')&'"')}>} Amount) - does work

Thanks!

Re: Element Function with dual field

anbu1984 — Tue, 23 Sep 2014 18:08:49 GMT

can you share sample data

Re: Element Function with dual field

bgerchikov — Tue, 23 Sep 2014 21:15:48 GMT

Ok, I found out myself:

The problem was caused by the fact that Field2 is a column in the data island table along with the other columns and has NULL values. When I extracted Field2 in the separate table with no NULL values, Element function started working as needed.

Re: Element Function with dual field

Wed, 24 Sep 2014 02:40:13 GMT

i'm glad to hear it..

Please mark your post as an answer and close this question.