Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

amien
Valued Contributor

how can i link these? do i need AGGR?

i have 2 tables:

table I:

date, value1

table II:

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?

2 Replies
dvqlikview
Honored Contributor II

how can i link these? do i need AGGR?

Have you considered using Indirect Set Analysis? I had used the Indirect Analysis for similar requirement.

Good luck!

Cheers - DV

Highlighted
MVP
MVP

how can i link these? do i need AGGR?

Amybe something like this?

sum(Value1 * Value2) / sum(total <Date> Value2)

This shoud work, I think...

Community Browser