Discussion Board for collaboration related to QlikView App Development.
Date(DateA) AS DateA,
Date(DateB) AS DateB,
I'm trying to get a straight table which shows:
Date | Balance | Target
Thanks for your help,
All you need to do is to name the two dates the same, e.g.
Date(DateA) AS Date,
Date(DateB) AS Date,
If possible you can concatenate two tables like below:
Then in a straight table add Date as dimesion and use Balance & Target in expression.
Ideally, I was hoping for an expression which may solve this.
I can't rename the fields to be the same as this would cause a loop
Try the following script:
NoConcatenate Load Date, Sum(Balance) as NewBalance, Sum(Target) as NewTarget
Resident TempOutput Group By Date;
Drop table TempOutput;