Filtering on an expression

Wed, 08 Dec 2010 18:15:50 GMT

Help please!!
I am using a variable as an expression to output a usage flag over the past 6 months to simply feedback into my straight table either 'Active Usage', '3Mths Nil Usage' or '6Mths Nil Usage'; all of which works hunky dory!
However, the 1st thing I was asked when demoing the app was can I please filter on 1 of the flags?
Having spent some time searching the forum & trying input boxes & even a slider by changing to '1', '3' & '6' I have reached something of an impasse & also a headache!
For info the variable is as per;
if(sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)))}>}SessionGUID_Counter)
+sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-1))}>}SessionGUID_Counter)
+sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-2))}>}SessionGUID_Counter)
+sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-3))}>}SessionGUID_Counter)
+sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-4))}>}SessionGUID_Counter)
+sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-5))}>}SessionGUID_Counter)=0,'6Mths Nil Usage',
if(sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)))}>}SessionGUID_Counter)
+sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-1))}>}SessionGUID_Counter)
+sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-2))}>}SessionGUID_Counter)=0,'3Mths Nil Usage','Active Usage'))

Can anyone help please?
Also, any ideas if/how I could make it a calculated dimension?

ps - I put forward the option of the search button from the 'Presentation tab & was roundly shouted down as for 1 it's a fairly ugly option

topic Filtering on an expression in QlikView

Filtering on an expression