topic Re: Help in Expression in QlikView

Help in Expression

Mon, 13 Oct 2014 10:02:01 GMT

Hi,

I have a line chart with one dimension and multiple expressions.

Dimension is Months

For some of the expressions, i have to calculate expression values as PREVIOUS MONTHS' VALUE - CURRENT MONTHS' VALUE

Is it possible to implement the same?

ali_hijazi — Mon, 13 Oct 2014 10:07:52 GMT

if 4 (April) is your current month (selected) then previous month would be as follows:

create a variable and name it vPreviousMonths

in the definition put

=max(Month) -1

then in your expression if it is sum(sales)

it would be sum(sales) - sum({<Month={$(vPreviousMonth)}>}Sales)

Hope this helps

ashfaq_haseeb — Mon, 13 Oct 2014 10:10:41 GMT

Hi,

Check this

Regards

ASHFAQ

ariel_klien — Mon, 13 Oct 2014 10:10:50 GMT

Hi,

You can try the command 'above'

something like above(sum(value))-sum(value) when the dimension is month.

Ariel

Mon, 13 Oct 2014 11:45:49 GMT

I have to write an expression such as

when YearField=2013, (100-(Prev Value-Curr Value)/Prev Value)*100 as Expr1

and for all other years it should be previous value of Expr1 -((Prev Value- Curr Value) /Prev Value) * 100 as Expr1

mdmukramali — Mon, 13 Oct 2014 12:00:00 GMT

Dear,

can you attach the sample file so that we can help you in a better way.

Thanks,

Mukram