topic Expression Help Required in App Development

Expression Help Required

samvile18 — Mon, 24 Apr 2023 09:55:11 GMT

Hi all,

Just a quick question from me, I'm struggling to get the correct expression to give me a quality score. The data is laid out in the following way:

RunDate	Metric	Measure	Value
01/03/2023	Cyclops_Title	Total count	15909416
01/03/2023	Cyclops_Title	Invalid_Name	923438
01/03/2023	Cyclops_Title	Inaccurate_Name	30814
01/03/2023	Cyclops_Title	Incomplete_Name	74848
01/03/2023	Cyclops_Title	Invalid_Title	246124
01/03/2023	Cyclops_Title	Inaccurate_Title	19061
01/03/2023	Cyclops_Title	Incomplete_Title	25686

So I'd need a % score in a new column where it divides the measure by the Total count...can anyone help me out please?

Re: Expression Help Required

Sabrina_V — Mon, 24 Apr 2023 09:58:51 GMT

Maybe try this :

Sum({<Measure-={'Total count'}>} Value) / Sum({<Measure={'Total count'}>} Value)

And then you need to format the measure in %

Re: Expression Help Required

samvile18 — Mon, 24 Apr 2023 10:27:37 GMT

That's what I tried originally but I can't get it to return anything other than null...no idea why it isn't working.

Re: Expression Help Required

Kushal_Chawda — Mon, 24 Apr 2023 11:21:11 GMT

@samvile18 providing sample with expected output will be useful to get correct answers quickly.

Re: Expression Help Required

samvile18 — Mon, 24 Apr 2023 11:51:39 GMT

I've copied the table I have in Qlik and I've added the data coming in too. Essentially I'd be hoping to have a % Score column next to each measure. So each measure under Cyclops_Address would use the relevant total.

Re: Expression Help Required

Sabrina_V — Mon, 24 Apr 2023 11:52:39 GMT

Sum({<Measure-={'Total count'}>} Value)/Sum(TOTAL {<Measure={'Total count'}>} Value)

Re: Expression Help Required

samvile18 — Mon, 24 Apr 2023 12:22:58 GMT

How would you extend this to cater for the different groups of Metric? Like in the following picture:

So anything under Cyclops_Address would need to use the Cyclops_Address Total count...whereas Cylcops_DOB would need to use the Cyclops_DOB Total count...and so on.

Re: Expression Help Required

Kushal_Chawda — Mon, 24 Apr 2023 12:31:49 GMT

@samvile18 It all depends on how you want to calculate your share. I am assuming for each Date and Metrics you would want share, but if date do not take part just use Metrics in Total qualifier

Sum({<Measure-={'Total count'}>} Value)/Sum(TOTAL <RunDate,Metrics>{<Measure={'Total count'}>} Value) or Sum({<Measure-={'Total count'}>} Value)/Sum(TOTAL <Metrics>{<Measure={'Total count'}>} Value)

Re: Expression Help Required

Sabrina_V — Mon, 24 Apr 2023 12:32:58 GMT

Sum({<Measure-={'Total count'}>} Value)/Sum(TOTAL <Metric> {<Measure={'Total count'}>} Value)

Re: Expression Help Required

samvile18 — Mon, 24 Apr 2023 12:35:04 GMT

You two are absolute legends - I thought Total but I was putting it in the wrong place because I'm an idiot. Thanks very much