Discussion Board for collaboration related to Creating Analytics for QlikView.
i have 2 tables:
date, value2, type
i want my pivot chart like this:
dimensions: date, type
expr : sum(value1), sum(value2).
value2, looks ok, but value1 has the problem because there is no type dimension in the source.
how can i split the sum of value1 into type, based on the ratio between types based on the sum of value2 of that day?
Have you considered using Indirect Set Analysis? I had used the Indirect Analysis for similar requirement.
Cheers - DV
Amybe something like this?
sum(Value1 * Value2) / sum(total <Date> Value2)
This shoud work, I think...