topic Re: expressions evaluation in QlikView

expressions evaluation

Tue, 20 Sep 2011 12:49:23 GMT

I want to do some strange things, namely:

i have some field, filled with variables names

For examle

Field:

-----------

Year

Month

Day

where Year, Month & Day are fields in other tables

In chart I wnat to hane an expression like =sum($(Field)

I mean if Filed=Year then expression should be sum(Year)

Is it possible to do this?

Re: expressions evaluation

sridhar240784 — Tue, 20 Sep 2011 14:49:24 GMT

If i understood your Question properly.Your expression should be like =sum($(=Field)

Check out the attached application.

Hope this helps you,

-Sridhar

Re: expressions evaluation

its_anandrjs — Tue, 20 Sep 2011 15:10:10 GMT

Hi,

I think you need to write a code some thing like below for expression calculation

=If(Getfieldselections(Year),Sum(Value))

See sample file

HTH

Rgds

Anand

Re: expressions evaluation

Tue, 20 Sep 2011 16:58:12 GMT

If Year, Month and Day are in different tables, just refer to them with the same fieldname so they all will line up irrespective of Yr, Mth or Day.

Re: expressions evaluation

Tue, 20 Sep 2011 17:02:09 GMT

Here is what the script look like (modified what Anand had attached previously).

Re: expressions evaluation

its_anandrjs — Tue, 20 Sep 2011 18:29:38 GMT

Hi,

In this type of requirements make a composite key which contains Year Month and Day values and use this key so in this case your problem solve with this you need to use this key as dimension.

HTH

Let me know tomorrow it is too late.

Rgds

Anand