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: 
amijit_hazarika
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.


Thanks

2 Replies
m_woolf
Master II
Master II

Try putting = in front of count

sunny_talwar

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

Capture.PNG