Discussion Board for collaboration on QlikView Scripting.
I hope, you can help me. I have two different tables, one with amounts and one with prices. I want to create only one table of these two and want to calculate e.g. a total price for an amount.
Could you please help me and give some hints or a link, where a solution is described?
Thanks very much in advance,Clemens
Go to Solution.
What is the final price/value you are looking for Car-Sales?
Article&'-'&Action as "Rate"
Or use something like this
I want to have a table that looks like this:
Try adding a transaction id and then Sum(Price) * Sum(Value)
thanks for your help. The combination of Article&'-'&Action is a good idea!
Thanks for your help. I`ll try to go on with the "key".
RowNo() as id,
You must add id as dimension if you want to show all your transactions but you can hide it if you want.