Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

philippon
New Contributor III

Pivot Table - Base 100 data

Hello.

I have a pivot table with 2 dimensions. First one is Date, second one is Product.
I would like to show the evolution of Products' Prices starting from 100 (rebased data).

Attached is the table that I would like to get. I have been trying to achieve this using First() function, but no luck...

Many thanks for your help.

Tags (1)
1 Reply
fosuzuki
Valued Contributor II

Pivot Table - Base 100 data

Hi,

Have you tried using set analysis?

Can you attach the QVW? At least for me, it is easier to help working on a sample QVW rather than talking conceptually.

Regards,

Fernando

Community Browser