Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to do a calculation on string?

Hi Qlik Enthusiasts,

I am working on improving the performance of a dashboard. I am getting stuck at the below scenario;

Count(Distinct{<Geography = , Level={0})>}) / sum(Distinct{<Geography = , Level={1,2})>}

I am taking them as string by putting single quotes and storing in a variable.

vPerformanceExpr = 'Count(Distinct{<Geography = , Level={0})>})' / 'sum(Distinct{<Geography = , Level={1,2})>}'

When I call the above variable it ain't working. However both the strings are working separately.


2 Replies
Master II
Master II

Try putting = in front of count


I am confused, what are you counting and summing here? You don't have any field within Count and Sum