Lock data to a spesific period

Anonymous — Fri, 26 Aug 2011 12:01:27 GMT

Not sure if this is the right forum but I will give it a try anyway.

I need to create both a table and a char with an index that is locked to this year and this year and last 6 months.

I have created the table and the chart and they shows the data but if I change year mye table and chart also changes.

I need for them to be locked no matter what I do in my other selections.

My calculated expression:

(

sum({<Aar={"=$(=(num(year(today()))))"}>}{<Mnd={">=$(=(num(month(today()))-6))"}>} CountOfResults)-

sum({<Aar={"=$(=(num(year(today()))))"}>}{<Mnd={">=$(=(num(month(today()))-6))"}>} OutOfLimit)-

sum({<Aar={"=$(=(num(year(today()))))"}>}{<Mnd={">=$(=(num(month(today()))-6))"}>} OutOfOuterLimit)

sum({<Aar={"=$(=(num(year(today()))))"}>}{<Mnd={">=$(=(num(month(today()))-6))"}>} CountOfResults)

)*100

Aar = year

Mnd = month

If I set a conditional calculation in my general tab it will only show 2011 figures, but of course only when I select 2011 from my year selection box.

Ideas anyone?

Hope to hear from you.

Dan

topic Lock data to a spesific period in QlikView

Lock data to a spesific period