Set Analysis not working

shumailh — Wed, 26 Jan 2011 10:38:09 GMT

I was trying to filter my date by using set analysis but its not working.



=COUNT({$<AIF = {P}, LoadMonth_Active = {$(#=ReportMonth)}, Bucket={0,1,2,3,4,5,6}>} AIF)

this loadmonth_active contains months of year 2010 i.e. jan, feb, mar.... dec whereas the variable ReportMonth contains a value 'dec'.

Earlier to that I tried loadday_active which contains days of last year with a variable ReportDay contains 31 which was working.

I am unable to understand what is the reason why the month code is not working. Can anybody help me in this regard.

Shumail

Set Analysis not working

sparur — Wed, 26 Jan 2011 11:53:39 GMT

Hello

why do you use $(#,,,) try like this:

COUNT({$<AIF = {P}, LoadMonth_Active = {'$(ReportMonth)'}, Bucket={0,1,2,3,4,5,6}>} AIF)

Set Analysis not working

shumailh — Wed, 26 Jan 2011 13:40:22 GMT

Thanks Sparur

topic Set Analysis not working in QlikView

Set Analysis not working

Set Analysis not working

Set Analysis not working