Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

Problem solving for constant moving targets

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

1 Reply
vishsaggi
Champion III
Champion III

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. ?