Discussion board where members can get started with QlikView.
I have made a scatter chart which shows the contract expiring date, material & its value.
There are many contracts with same contract number linked to a specific material having different value. so we want to show as two different bubbles.
To seperate similar contract number cases, i have added a serial number field as the dimention to show the data.
Every time i have to upload a new excel sheet, I have to update the serial numbers.
Is it possible to generate serial number automatically depending upon the data lines uploaded & use it as a dimention.
Thanks in advance!
Go to Solution.
You can auto generate a counter field to a table using Rowno() for example
Gr8 Thanks it works!
You made my day!