topic Re: Position in QlikView

Position

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I have pro year/ month the sales of specific cars e.g. opel, fiat, Mercedes etc.

Now i want to have a pivot table

with for the actual year the sells of cars and the position

the previous year the sells of cars and the position within that year

e.g.

2014 2013

sells position

fiat 1000 1 fiat 800 3

opel 800 2 Opel 900 1

Mercedes 700 3 Mercedes 850 2

you can see fiat 2014 position 1 2013 position 3

opel 2014 position 2 2013 position 1

Mercedes 2014 position 3 2013 position 2

How to realise this?

Re: Position

MarcoWedel — Fri, 14 Nov 2014 21:24:53 GMT

Hi,

one solution could be:

tabCarSales:
LOAD *,
    Month(MonthName) as Month,
    Ceil(Month(MonthName)/3) as Quarter,
    QuarterName(MonthName) as QuarterName,
    Year(MonthName) as Year;   
LOAD *,
    Ceil(Rand()*15000)as Sales,
    MonthName(AddMonths(MakeDate(2010),IterNo()-1)) as MonthName
Inline [
Car Manufacturer
Audi
BMW, Mini
Fiat
Ford
Mercedes-Benz
Opel
Porsche
Volkswagen
]
While AddMonths(MakeDate(2010),IterNo()-1) <= Today();

hope this helps

regards

Marco

Re: Position

jsakalis — Fri, 14 Nov 2014 21:26:01 GMT

Hi Ama,

Please see attached app.