Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
haneeshmarella
Contributor II

How to use calculated expressions in resident load?

Hi guys,

As an example of sample data, I have 3 fields - Date, Worker, Label#.

I have a calculated expression Count(TOTAL <Date> DISTINCT {<Worker*={"*}>} (Label#))

I am trying to move this calculated expression to back end, to make the front end faster as it is very slow currently.  How do I move that expression to back end using it as resident load?

Thanks in advance! 

1 Reply
zhadrakas
Valued Contributor

Re: How to use calculated expressions in resident load?

here is a prototype for your script:
replace TEST with your current Load Statement

TEST:
LOAD * INLINE [
Date, Worker, Label
14, 1, N
14, 2, N
15, 1, Y
15, 2, Y
16, 2, A
16, 1, C
16, 1, F
16, 1, B
16, 1, G
];

inner join
Load Date,
count(distinct Label) as EXPR_1
Resident TEST
Where len(trim(Worker))>0
GROUP BY Date
;
regards
tim