Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Luke_Killer_IT
Creator
Creator

how to count selected data

hello

I have a problem I need it to calculate data by a formula I have built something like this but it doesn't work properly and it doesn't count properly do you have any idea how to do it

this is the first formula:

if(V_BelegPosPlatten.Artikel='2*' or V_BelegPosPlatten.Artikel='133*' or V_BelegPosPlatten.Artikel='144*',((sum({<V_BelegPosPlatten.BelegArt={'U'},Merkmal={69},SMLeiste={'BR-Grund'},V_BelegPosPlatten.offen={1}>}Auspr*V_BelegPosPlatten.Menge)*2
+
sum({<V_BelegPosPlatten.BelegArt={'U'},Merkmal={152},V_BelegPosPlatten.offen={1},SMLeiste={'BR-Grund'}>}Auspr*V_BelegPosPlatten.Menge))/16000))

this is the second formula:

(sum({<V_BelegPosPlatten.BelegArt={'U'},V_BelegPosPlatten.Artikel={"2*"},V_BelegPosPlatten.Artikel={"133*"},V_BelegPosPlatten.Artikel={"144*"},Merkmal={69},SMLeiste={'BR-Grund'},V_BelegPosPlatten.offen={1}>}Auspr*V_BelegPosPlatten.Menge)*2
+
sum({<V_BelegPosPlatten.BelegArt={'U'},V_BelegPosPlatten.Artikel={"2*"},V_BelegPosPlatten.Artikel={"133*"},V_BelegPosPlatten.Artikel={"144*"},Merkmal={152},V_BelegPosPlatten.offen={1},SMLeiste={'BR-Grund'}>}Auspr*V_BelegPosPlatten.Menge))/16000

Labels (2)
1 Reply