Discussion board where members can get started with QlikView.
I need your help to solve this issue.
The segment is a Dimension expression of extraction the first 2 letters from a code
I can not do the same with the PY...
Attached the example:
Your tables all were disconnected and you need to modify your script. Try like below:
LOAD CODE_CY AS CODE,
(biff, embedded labels, table is cd$);
LOAD CODE_PD AS CODE,
(biff, embedded labels, table is pd$);
LOAD CODE_PW AS CODE,
(biff, embedded labels, table is pw$);
LOAD CODE_PY AS CODE,
(biff, embedded labels, table is py$);
So you will get only one table.
Use Dimension: Left(CODE,2)
Expression: Sum(Current_Day) etc
Thanks, the problem is that i can not touch the script. I can just do free analysis...
May be this:
=Sum(Aggr(If(Left(CODE_CY, 2) = Left(CODE_PD, 2), [Previous Day], 0), CODE_CY, CODE_PD))
But remember the performance will be very poor because you are essentially creating a Cartesian Product with your Aggr() function.