topic Re: Dimension - expression in QlikView

Dimension - expression

Wed, 03 Feb 2016 15:01:51 GMT

hello,

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

Thanks

Attached the example:

Wed, 03 Feb 2016 18:18:10 GMT

Your tables all were disconnected and you need to modify your script. Try like below:

Data:

LOAD CODE_CY AS CODE,

[Current Day]

FROM

C:\Users\vera\Desktop\Datos.xls

(biff, embedded labels, table is cd$);

Join(Data)

LOAD CODE_PD AS CODE,

[Previous Day]

FROM

C:\Users\vera\Desktop\Datos.xls

(biff, embedded labels, table is pd$);

Join(Data)

LOAD CODE_PW AS CODE,

[Previous Week]

FROM

C:\Users\vera\Desktop\Datos.xls

(biff, embedded labels, table is pw$);

Join(Data)

LOAD CODE_PY AS CODE,

[Previous Year]

FROM

C:\Users\vera\Desktop\Datos.xls

(biff, embedded labels, table is py$);

So you will get only one table.

Use Dimension: Left(CODE,2)

Expression: Sum(Current_Day) etc

Wed, 03 Feb 2016 18:54:05 GMT

Thanks, the problem is that i can not touch the script. I can just do free analysis...

Thanks

sunny_talwar — Wed, 03 Feb 2016 19:53:17 GMT

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.