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 |
When you create a message, in the upper right part you will see advanced editor.
Now you will see the attachment option below right.
Could you please send a part of your data or the app, so that I could resolve the issue finally.
if u could do this and give me some explanaton with it, it would be really amazing!
Hi, I´m a little bit unsure of what you are trying to achieve.
I´ve fixed your Set Analysis expression, but as QlikRajan said, Set Analyisis can't skip dimensional filtering inside a chart. To do this, you need to use TOTAL .
Attached you will find an example with expression Inv.zuordnung - TOTAL . In this case, the expression SUM(Selling Price) is being filtered only by Category dimension inside the chart
i actually want to create 4 barcharts.
The first barchart should show me the sum for only "Festkontraktierte Verlängerung"
The second barchart the sum for only "36 Monate"
The third barchart the sum for only "48 Monate"
and the fourth for the sum of only "60 Monate"
I will work on it and get back to you shortly.
Hi Thanh:
I have created 4 different charts as per requirements. I created some of the fields in script and then with the help of set analysis and conditional dimensions created these 4 charts. Please find attached.
Let me know if this is what you were looking for.
Unfortunetly i can't load it into my script. maybe i'm just too stupid for it. but this is how i add ur solution into my script
but it shows me 3 errors....
1. Error
2. Error
3. Error
My origin script basically looks like this
Main script
Basisdaten script
could u may help me adding ur solution to my basic script?
could u help me out there?
I will get back to you shortly. I will work on this after my office hours.