topic Toggle select value with Set Analysis with AGGR in QlikView

Toggle select value with Set Analysis with AGGR

james — Fri, 21 Aug 2015 17:11:50 GMT

All,

I am able to select a field called 'Item' using toggle select and the search string as follows

='=(sum(aggr(DISTINCT

if((Sum([Full Consumption])/Sum([Onhand USD])) <4.0,

Count( Item),0),

Item) ))'

However, once i try to introduce Set analysis into this expression, it wont render...

='=(sum(aggr(DISTINCT

if((Sum({$<Level_Flag= {'0'},Filter = {'1'}>} [Full Consumption])/Sum({$<Level_Flag= {'0'},Filter = {'1'}>} [Onhand USD])) <4.0,

Count( Item),0),

Item) ))'

any ideas on a workaround???

swuehl — Fri, 21 Aug 2015 18:00:04 GMT

That's probably due to the single quotes in your set modifiers being misinterpreted.

Try

='=(sum(aggr(DISTINCT

if((Sum({$<Level_Flag= {0},Filter = {1}>} [Full Consumption])/Sum({$<Level_Flag= {0},Filter = {1}>} [Onhand USD])) <4.0,

Count( Item),0),

Item) ))'

='=(sum(aggr(DISTINCT

if((Sum({$<Level_Flag= {"0"},Filter = {"1"}>} [Full Consumption])/Sum({$<Level_Flag= {"0"},Filter = {"1"}>} [Onhand USD])) <4.0,

Count( Item),0),

Item) ))'

james — Fri, 21 Aug 2015 21:05:34 GMT

Yes the single quotes was the issue...

Thanks