topic how to block data? in QlikView

how to block data?

rmuhammad — Wed, 25 Nov 2020 16:16:04 GMT

any suggestions on how to block this data when total drop 25?

chart type is pivot table. I want to show hypen in vol 1,2,3 if the row total is less then 25 as highlighted in example below

ychaitanya — Thu, 22 Mar 2018 20:20:15 GMT

i would calculate like this

IF( AGGR( SUM(VALUE),GROUP)<25,NUll(),SUM(VALUE))

vishsaggi — Thu, 22 Mar 2018 20:44:37 GMT

Another way can be tweaking a little of Chaitanya expr Try like:

Dim: Group

Expr:

= IF(Aggr(Rangesum(Vol1, Vol2, Vol3), Group) < 25, '-', Sum(Vol1))

= IF(Aggr(Rangesum(Vol1, Vol2, Vol3), Group) < 25, '-', Sum(Vol2))

= IF(Aggr(Rangesum(Vol1, Vol2, Vol3), Group) < 25, '-', Sum(Vol3))

= Sum(Aggr(Rangesum(Vol1, Vol2, Vol3), Group))

Last expr is for Totals.

Below is how it looks