Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Summe Anschaffungskosten Produk A | Summe Anschaffungskosten Produk B | Summe Anschaffungskosten Produk C | |
---|---|---|---|
33000 | 37500 | 8000 |
have you found a solution for my errors yet?
Hi there,
You are loading the wrong table in the script above. In your second script string, you load from A-Import_LPM, and then you enrich with AVG_PV and Zins. In the first script string you show, you load your main table again from A-Import_LPM. Zins is not in there, and so this is the first error message you get. The other follow out of the first.
Solution is to save the result of your joins in a file, and then use this file to load your main data from. This way, zins will be there, and the script should work.
Regards,
Johan
could you show me, how my new file should look like? it is completely new for me, working/manipulating with the script.
Could you upload your Qvw (that works easier than rescripting everything)
there is already one attached
Please have a look at this one. Hope it will not give you the errors anymore if you can complete the sources correctly.
it is working! thank you very much
Hey..I was travelling last week for work. I could not have a chance to get back to qlik community. I have seen someone has already helped you on this. good luck
its ok, u helped me a lot and thank you very much for your help! but could you answer on my private message please ?
I have not seen your msg, cud you send again