Simple table

absekrafi — Mon, 22 Mar 2021 12:48:12 GMT

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

Re: Simple table

QFabian — Mon, 22 Mar 2021 14:31:53 GMT

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

topic Re: Simple table in QlikView

Simple table

Re: Simple table