How to do a calculation on string?

[amijit_hazarika]

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

[m_woolf]

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