Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.


show and compare calculated values in a chart/ graphic widget

I would like to show graphical representation of the calculated difference in total of different products.

amsterdamD4000Incoming prod A11060,8amsterdamD4500Outgoing prod A242150,05945
amsterdamD4200Incoming prod B162,2amsterdamD4523Outgoing prod B242049,94055
Totaal1123 Totaal841282

Its easy to show in a chart the totals for products for current year, ( = Sum({< Year={$(=Max(Jaar))} >} Receipt.Weight.Kilo))

but the user wants to show :

1. Difference between all four IN en OUT Products :  (where the % shows in the above tabel)

2. and  with two different products, the difference for thetwo  outgoing products should be shown. (The coloured % values in the above table is the comparison between D4500/D4523 etc...)

Amoung this example, I have a list of other/ different products to compare in the same way. I have attached a xls ans an example.

What is best practice to show this calculated values in a graphical form. : how to 'filter' the products and what sort of chart/ graphic widget should/could be used to represent these type of calculated values...

A second challenge is to show these values in time e.g. per week etc...

Community Browser