Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikview community,
I have a simple table with dimension product this table has many expressions.
I want to add an expression that depends also of an other dimension (factorry).
I wrote this new expression as :
=Aggr(Sum({<ARTICLE={'M'}>} STOCK), factorry) but it didn't work.
Any suggetion please?
Thank you
Hi @absekrafi , since aggr returns a logic table, you should envolve all of that in another sum.
sum(Aggr(Sum({<ARTICLE={'M'}>} STOCK), factorry))
But, i would like to know more details about your current chart table, and expected result.
Because if you say that your new expression have to depend on factorry, that can means that you want to group by that field? or just the result has to change if a value from that dimension is selected...