topic problem in table in QlikView

problem in table

Tue, 12 Apr 2016 14:39:11 GMT

Hello

I am working with a straight table which has a column of sum of sales. Now the requirement is to add a column sum(sales) with condition on another column which is Revenue.so it should be sum(sales) if rev>0.

I added both the columns but both were giving the same result, which I thought was fine, but for a particular bill that was not true so I added the dimension 'bill' to the table and chose the option sum of rows on conditional sum of sales column. That gives the perfect answer to the solution. BUT the problem is neither I can have dimension 'bill' in my table nor the straight table. and if i remove the dimension bill it gives the same sum of sales for both columns.

So is this possible that adding a dimension can alter the result of expression. how to deal with this. please help

Thanks in advance

Re: problem in table

settu_periasamy — Tue, 12 Apr 2016 16:24:32 GMT

May be try with aggregation, like

=aggr (sum (sales),bill)

Re: problem in table

Tue, 12 Apr 2016 16:44:19 GMT

I tried this, but for this I willl have to add bill as dimension in my table, which is not required

Re: problem in table

Tue, 12 Apr 2016 17:38:47 GMT

Can you please share sample QVW for reference or at least temp data?

Re: problem in table

trdandamudi — Tue, 12 Apr 2016 17:52:41 GMT

May be this...

=Sum({<rev={">0"}>} Sales)

Re: problem in table

Tue, 12 Apr 2016 18:24:14 GMT

yes I tried this but when I add dimension bill to this table it alter the result. then it shows different sum

Re: problem in table

settu_periasamy — Wed, 13 Apr 2016 02:16:30 GMT

Can you share the sample?