How to add 2 Expressions which rule out themselves

[Anonymous]

Hello,Im very new to Qlik, I have question if is it possible to add two expresions in one pivot table where for example:

Product is dimension. Products have their atributes, and in one expresion im using atribute =0 and in second expression im using atribute=1, and it shows not in same row, but under. Is it possible to see in one row product and two expressions

Could someone explain it to me, if its even possible?

expressions are :

1st:

=(num(sum(if(atribute=16777234 and  and mod(Atrybut,2)=0,Sales,0))

+sum(if(atribute=16777238 and mod(Atrybut,2)=0,Sales,0))

+sum(if(atribute=33554450  and mod(Atrybut,2)=0,Sales,0))

+sum(if(atribute=33554454 and mod(Atrybut,2)=0,Sales,0))

+sum(if(atribute=67108882 and mod(Atrybut,2)=0,Sales,0))

+sum(if(atribute=67108886 and mod(Atrybut,2)=0,-Sales,0))

+sum(if(atribute=486539282 and mod(Atrybut,2)=0,Sales,0))

+sum(if(atribute=486539286 and mod(Atrybut,2)=0,-Sales,0))

+sum(if(atribute=184549394 and mod(Atrybut,2)=0,Sales,0))

+sum(if(atribute=184549398  and mod(Atrybut,2)=0,Sales,0)),'# ##0,00')

2nd:

sum(if(atribute= 218103808, Sales, 0))

[sunny_talwar]

Not entirely sure what you trying to do. Can you may be provide a sample with your expected output?

[Anonymous]

Well, I'm trying to count stocktaking and sales which was till the stocktaking. I already counted the stocktaking, but i dont know how to count the sales to date (DataInwentary). becouse the atributes of Sales is in the first expresssion and count stocktakin in the second has different atributes. Atritubtes belongs to same table in  AllSales, but atribut says what kind of Sale was it.

I'm trying to get row with the stocktaking, the difference between products(done)and Sales to date(DataInwentary)

Date(DataInwentary) im getting on same atribute as stocktaking bcs its date of the end of it.