Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview User
I have spent many hours in the last few days trying to solve some problems I have with regards to displaying Targets in a table
My problem lies with the fact that month on month the targets can change and I am having difficulty solving 3 issues with regards to this
I have attached a QVW which contains dummy data, but the data is in the exact structure in which I am receiving it.
I was wondering if you could kindly point me in the right direction of how to solve some of the problems. I don't expect anyone to solve them all for me, but I have a feeling that one problem may solve another one
If you have the time to take a look, then that would be great!
Kind Regards
Helen
Why cant you create a Autonumber(Metric&FactDate) AS %KeyField
Create this in both your table Dim table and Target table and rename the fields in each tables which are same.
IF possible can you share your sample excel files as well to work on script and reload data. ?