Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
Not applicable

set analisys

Dear all,

I'm using the following expression, but I aim to know how it works. Let me add more detail: in my intention,

I would sum all the purchase values till August (MY_MONTH) or other selected month

aggr(sum({<PURCH_MONTH={"<= $(=only(MY_MONTH))"}>} PURCHASE_VALUE),MY_YEAR, MY_SUPPLIER)

It seems correct, because I get the required values.

Now, I need to  calculate another value but for PURCH_MONTH < MY_MONTH.

I was convinced that I could do it changing the condition  <PURCH_MONTH= {" < $(=only(MY_MONTH))......

but it doesn't work.

Does anyone know what I'm doing wrong ?

Thanks in advance

stefan