topic Re: how to evaluate an expression? in QlikView

how to evaluate an expression?

rcandeo — Mon, 29 Jul 2013 20:42:17 GMT

Hi, I have some formulas that I need to bring me results. So I´m trying to find the correct comands with no sucess.

I´ve created an aplications only with these lines on script:

LOAD * INLINE [

F1, F2

A, (5*8)

B, (2*1)

C, (1+1)

];

Then I´ve create a table showing F1, F2 and these expression:

=$(=F2)

The problem is that my table only shows the result in the expression when I select something. It shows me NULL values it I intend to show all the records.

Any idea why?

Re: how to evaluate an expression?

stevelord — Mon, 29 Jul 2013 21:11:40 GMT

I have a table that shows nulls for some records when I leave a particular field unselected, then shows values when I select something in that field. In my case the field is called Source, and even though it is not in my straight chart, the straight chart is seeing a conflict in the record source and discards the record rather than show the most current version as it should. I don't know why mine behaves that way, but it sounds like you have the same kind of something causing a conflict that resolves only when you select something in that field. Not sure really how to fix it since I needed the particular field to select by if not to aggregate my table by...

Re: how to evaluate an expression?

rwunderlich — Mon, 29 Jul 2013 22:01:56 GMT

I think the problem is that the =$(=F2) calculates once per chart, not on a row basis. So when there is only one value available for F2, it works, otherwise not.

There is an evaluate() function available in script that will allow you to evaluate the expressions. Or do you have to do the evaluation in the chart?

-Rob

Re: how to evaluate an expression?

Sokkorn — Tue, 30 Jul 2013 01:21:13 GMT

Hi,

It will work with this expression:

=Pick(Match(F2,$(=Chr(39)& Concat(F2, Chr(39) & ',' & Chr(39),F1) & Chr(39))),$(=Concat(F2,',',F1)))

Regards,

Sokkorn

Re: how to evaluate an expression?

rcandeo — Tue, 30 Jul 2013 17:15:27 GMT

Hi, I couldn´t use this expression, but I became curious how to use it. Can you show me how please?