Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Evolution rate as a calculated dimension

Hello

First of all I am a beginner.

Let say that we have a table with 6 fields : Customer, customer familly, ,order number, year,  Sales, gross margin

The goal is to produced a bubble chart having as axis : Turnover increase rate (Selected year versus the year before), gross margin rate (gross margin / sales)

The bubble should represent the gross margin value., for a given customer

The chart should change if a customer familly is selected or changed

I have struggled a little bit with nested agreagation (aggr), and must adminted that i could make it work.

Must be classic and stupid

Many thanks in advance.

Lionel

Community Browser