QlikView App Dev

[kaivalentino]

Hi!

I want to see only photos with positive value stock!

I tried coding below but I could not get it to work:

=if(Aggr(Rank(Sum({<$(v_SOHQty_Wh)<>'0'>}$(v_SOHQty_Wh)),4,1),[Continuative SKU]),ImageLinkURLContinuativeColor)

Any advice would be great,

Thanks!

[rubenmarin]

Hi, where is this show and what dimensions are used can change the needed expression.

In example in a table with product as dimension the expression could be: If(Sum(Stock)>0, ImageLink)

In a dimenion it could be: Aggr(If(Sum(Stock)>0, ImageLink), ImageLink)