Even if we use set analysis in our expression it will show wrong values..

Mon, 28 Oct 2013 16:01:32 GMT

Fiends,

I have have an expression to calculate the cumulative total based on the isoWeek selection. We have list-box to select the isoWeek.

The below the expression have been working for some scenario. In some ceases not working.

When zooming the portion of the area in the charts which is showing wrong values. How to make the zoom to work correctly with set analysis?

Ceil((Aggr(RangeSum(Above(Sum({$<isoWeek=>}), 0, RowNo())), isoWeek)) / (Aggr(RangeSum(Above(Sum({$<[isoWeek]=>} ), 0, RowNo())), isoWeek))*100,0.01)

Kindly help me resolve the problem.

Regards...

Thiru.

Re: Even if we use set analysis in our expression it will show wrong values..

tresB — Mon, 28 Oct 2013 16:08:48 GMT

The set section (<isoWeek=>) in your expression actually AVOIDs the selection of isoWeek field. If you want your expression to respond to the selection on that field, you have to remove the set section.

topic Even if we use set analysis in our expression it will show wrong values.. in QlikView

Even if we use set analysis in our expression it will show wrong values..

Re: Even if we use set analysis in our expression it will show wrong values..