Problem with denominator within set analysis

Thu, 29 Aug 2013 11:00:40 GMT

I have a line graph with two cyclic filters; the x axis being time periods cyclic filter and the y axis being business fields cyclic filter.

I have to plot the counts per month as a % of the current counts for the business fields chosen within the cyclic filter.

I am trying to use set analysis and I am restricting the denominator to the latest month.

sum({<[%Data Key]={'Market'},
$(=concat({1<$Field-={'Field1','Field2'}>} '[' & $Field & ']=',','))>}

[%Volume])
/
sum({<

[%Data Key]={'Market'},

[%Date Order]={

$(=max([%Date Order]))},

$(=concat({1<$Field-={'Field1','Field2','%Date Order'}>} '[' & $Field & ']=',','))>}

[%Volume])

However my graph is then only displaying the current month.

Any help would be appreciated.

Thanks

topic Problem with denominator within set analysis in QlikView