topic How to do a calculation on string? in QlikView

How to do a calculation on string?

amijit_hazarika — Wed, 25 Apr 2018 10:11:44 GMT

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 — Wed, 25 Apr 2018 11:56:36 GMT

Try putting = in front of count

sunny_talwar — Wed, 25 Apr 2018 11:58:51 GMT

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