topic Re: Expression in QlikView

Expression

upaliwije — Fri, 10 Oct 2014 05:55:15 GMT

Sum(ACTUAL)/({$<YEAR = {$(=Max(YEAR))}>}$(=$(=vActual))*100)

The above expression is not working. Pls help me to correct it

Re: Expression

PrashantSangle — Fri, 10 Oct 2014 05:57:47 GMT

Hi,

Try like

Sum(ACTUAL)/({$<YEAR = {"$(=Max(YEAR))"}>} $(vActual))*100)

Regards,

Re: Expression

jonathandienst — Fri, 10 Oct 2014 06:04:21 GMT

Not sure what you are trying to achieve, but you are missing an aggregation function (Min, Mx, Sum, Count etc) here:

Sum(ACTUAL) / ({$<YEAR = {$(....

HTH

Jonathan

Re: Expression

upaliwije — Fri, 10 Oct 2014 06:07:27 GMT

Not working please

Re: Expression

upaliwije — Fri, 10 Oct 2014 06:10:16 GMT

What I am Trying to achieve is to calculate a ratio where $(vActual) is variable. That variable I want to apply to a particular that is selected by user

Re: Expression

PrashantSangle — Fri, 10 Oct 2014 06:15:48 GMT

Hi,

my bad

try this,

Sum(ACTUAL)/Sum({$<YEAR = {"$(=Max(YEAR))"}>} $(vActual))*100)

Sum(ACTUAL)/Sum({$<YEAR = {"$(=Max(YEAR))"}>} vActual)*100)

Regards

Re: Expression

jonathandienst — Fri, 10 Oct 2014 06:19:21 GMT

Have you tried this?

Sum(ACTUAL) / vActual * 100

Re: Expression

upaliwije — Fri, 10 Oct 2014 06:23:25 GMT

That is working. But I want to specify Selected year and and in another expression Year-1

Re: Expression

upaliwije — Fri, 10 Oct 2014 06:25:19 GMT

Still not working

my vActual variable=sum({$<DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

Re: Expression

its_anandrjs — Fri, 10 Oct 2014 06:27:46 GMT

Then please use GetfieldSelections() function with field name will help you better.

Re: Expression

upaliwije — Fri, 10 Oct 2014 06:31:13 GMT

Sorry

I have no idea about that function. Pls show an example

Re: Expression

PrashantSangle — Fri, 10 Oct 2014 06:45:20 GMT

Hi,

If possible upload sample apps.

Regards

Re: Expression

Fri, 10 Oct 2014 06:52:02 GMT

Try this

Sum(ACTUAL)/sum({$<YEAR = {$(=Max(YEAR))}>} vActual*100)

Re: Expression

jagan — Fri, 10 Oct 2014 06:56:17 GMT

Hi,

For selected Year use this variable

vActual = sum({$<DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

For previous Year use this variable

vActualPreviousYear = sum({$<Year={$(=Max(Year) - 1)}, DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

Hope this helps you.

Regards,

Jagan.

Re: Expression

jagan — Fri, 10 Oct 2014 06:58:01 GMT

Hi,

If you want the apply the same for Sum(ACTUAL) then use below

Sum(ACTUAL) / sum({$<DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

For previous Year use this

Sum({$<Year={$(=Max(Year) - 1)}>}ACTUAL) / sum({$<Year={$(=Max(Year) - 1)}, DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

Hope this helps you.

Regards,

Jagan.

Re: Expression

upaliwije — Fri, 10 Oct 2014 07:03:43 GMT

Thanks Jagan

It is ok. Cant I keep the variable as it is edit the expression to suit the year

Re: Expression

jagan — Fri, 10 Oct 2014 07:18:07 GMT

Hi,

If you are selecting year by default then this will give you the selected year value.

Sum(ACTUAL) / sum({$<DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

If you are not selecting the year and you want the latest year then use below expression

Sum(ACTUAL) / sum({$<DESCRIPTION={'GROSS_PREMIUM'}, Year={$(=Max(Year) - 1)}>}ACTUAL)

Hope this helps you.

Regards,

jagan.