Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dinosaur91
Contributor III
Contributor III

How to add 2 Expressions which rule out themselves

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

Example.jpg

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

2 Replies
sunny_talwar

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

dinosaur91
Contributor III
Contributor III
Author

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.