topic SET modifier in Month doesn't work in QlikView

SET modifier in Month doesn't work

Mon, 18 Jan 2010 09:28:11 GMT

Hi all,

I am facing an issue on development with SET. We have the following SET statement calcuating the percentage change with previous data:

(sum({$<RiskMonth={$(=Only(Month))}>} Risk_Monthly_Total)- sum({$<RiskMonth={$(=Only(Month)-1)}>} Risk_Monthly_Total))/sum({$<RiskMonth={$(=Only(Month)-1)}>} Risk_Monthly_Total)

We found that the statement of sum({$<RiskMonth={$(=Only(Month)-1)}>} Risk_Monthly_Total) is not working. We tried to test the Month-1 in the same application on a new textbox, but it just worked fine (i.e, showing the previous month). No matter how we modified the statement, it's final result is Zero.

We have optimized our QVW data structure so no synthetic key exist. May anybody help out on this issue? Thanks in advance!

William

SET modifier in Month doesn't work

Mon, 18 Jan 2010 10:01:05 GMT

Hi William,

please provide a small QV document we can work with.

Most of the time there are mixed formats if SET analysis is not working.

Rainer

SET modifier in Month doesn't work

Mon, 18 Jan 2010 10:26:35 GMT

Hi Rainer,

Thanks for your instant response. Please find the trimmed version for your reference.

William

SET modifier in Month doesn't work

Mon, 18 Jan 2010 14:14:14 GMT

Hi William,

RiskMonth, Month and RiskMonthly_Total did not have corresponding values in all cases (see the table box in the application).

It seems to me that this is the main problem you have.

Let me know if you need some more help.

Rainer