Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
haneeshmarella
Creator II
Creator 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
Partner - Creator II
Partner - Creator II

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

what exactly do you want to calculate? 


total numbers of Label# where Worker is not empty?

 

haneeshmarella
Creator II
Creator II
Author

Hello,

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