topic Re: How to keep expression as constant? in QlikView

How to keep expression as constant?

Sat, 06 Jul 2013 09:05:33 GMT

Hi,

Question on data handling in a scattered plot

Selections: Year (2011,2012)

Dimension: Year, Area

Expressions:

(1) Sum(Profit) - x-axis

(2) Volume% - y axis

In the scattered plot setup, how do i formulate my expression to force expression (1) to use 2011(min Year) profit for BOTH years? The idea is to show where the volume(%) went from 2011-2012 having kept profit in 2011 as a constant.

I've tried using Sum(Total) but it didn't take care of the Area

Sum(Total{<Year= {$(= min(Year))}>} [Profit])

Thanks!

CONG

Re: How to keep expression as constant?

er_mohit — Sat, 06 Jul 2013 09:13:46 GMT

have you tried Sum(Total{<Year=, >} [Profit])

updated by me

Sum(TOTAL{$<Area=,Year={"(=min(Year))"}>} [Profit])

Re: How to keep expression as constant?

Sat, 06 Jul 2013 09:20:00 GMT

That would have taken in all the data from 2011 to 2012... What i did using below already properly separate the data in the first dimension (Year) but does not generate the correct data for the 2nd dimension (Area). Now all my Area returns the same profit (2011 total)