query combining differents fields from 2 different columns
Asset cost
Product
1000
A
25000
B
8000
C
4000
A
15000
A
12000
B
500
B
13000
A
Hello Community, I would like to sum up every cost which refers to their own product
The query should be like this
if product=A, then sum up every asset costs referring to product A. If product= B, then sum up every asset costs referring to product B and if product C sum up every asset costs referring to product C
Qlikview should give out the result in this form
Sum Asset Cost Product A
Sum Asset Cost Product B
Sum Asset Cost Product C
33000
37500
8000
in german
Anschaffungskosten
Produkt
1000
A
25000
B
8000
C
4000
A
15000
A
12000
B
500
B
13000
A
Hallo Community, ich würde gerne aus der obigen Tabelle, überall wo Produkt A, B oder C vorkommen die Anschaffungskosten miteinander addieren.
Die Abfrage wäre,
Wenn Produkt= A, dann addiere alle Anschaffungskosten bzgl. Produkt A, Wenn Produkt= B, dann addiere alle AK bzgl. B, wenn Produkt=C dann addiere alle AK bzgl C
Qlikview soll die Ergebnisse später in Form eines Tabellendiagramms ausgeben.
i actually have still one problem left. everytime if i want to load a new excel database which i named like the the excel database before and which got the same fields (i added some more fields but it should not cause any problems with the loading) by clicking on the button "load script" it always shows me an error that it couldnt find some fields. so i always have to load the script manually by deleting the database in the script and readd it by selecting the database though giving the path. it s quite annoying to do it everytime cos i have a lot of database with different values, but the built of the database is still the same. usually it sould work on by clicking on the "script loading button" but it does not. anyone knows this problem?
In order to load a new file (enriched I guess), you need to place this file in the exact directory as the old one, with the same name. Then, if the same variables are in (an extra capital in the name can be a difference and cause an error to occur), the reload should be ok.
