Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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