Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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...

Kindly help me resolve the problem.

Regards...

Thiru.

1 Reply
MVP
MVP

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

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.

Community Browser