Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

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

what exactly do you want to calculate? 


total numbers of Label# where Worker is not empty?

 

Highlighted
Creator II
Creator II

Hello,

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