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! 

Labels (3)
2 Replies
waszcma1
Contributor

Re: How to use calculated expressions in resident load?

Count(TOTAL <Date> DISTINCT {<Worker*={"*"}>} (Label#))

what exactly do you want to calculate? 


total numbers of Label# where Worker is not empty?

 

haneeshmarella
Contributor II

Re: How to use calculated expressions in resident load?

Hello,

That's correct, I am looking to count the total distinct labels for all the workers that is not empty.