topic Re: please correct this sum expression in QlikView

please correct this sum expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to sum the patient based on their gender and status and wrote this formula

sum([Patient count])/sum(TOTAL{<Gender{,Status}>}[Patient count])

it is saying error in set expression

please let me know the correct syntax,

regards,

Anuradha

Re: please correct this sum expression

YoussefBelloum — Fri, 27 Jul 2018 08:01:22 GMT

Hi,

maybe this:

sum([Patient count])/sum(TOTAL{<Gender,Status}>}[Patient count])

Re: please correct this sum expression

swuehl — Fri, 27 Jul 2018 08:51:09 GMT

You need to decide if you want to limit the aggregation scope regarding the chart dimensions or selections:

I guess you want to ignore chart dimensions besides Gender and Status:

=sum([Patient count]) / sum(TOTAL<Gender,Status> [Patient count])

The Aggregation Scope

Re: please correct this sum expression

YoussefBelloum — Fri, 27 Jul 2018 08:54:54 GMT

Hi Stefan, by suggesting your above expression, I think you mean: you want to limit the aggregation score regarding the chart dimension.. I'm I wrong ?

because to ignore chart dimensions, we need to exclude them in set analysis, right ?

Re: please correct this sum expression

tresB — Fri, 27 Jul 2018 08:58:40 GMT

because to ignore chart dimensions, we need to exclude them in set analysis, right ?

NO.

Rather, to ignore chart dimensions, we need to use TOTAL qualifier with the dimensions accordingly. Set analysis has nothing to do with dimension ignorance but selection ignorance, irrespective of chart dimensions.

Re: please correct this sum expression

Anonymous — Fri, 27 Jul 2018 09:10:26 GMT

thanks that is working

Re: please correct this sum expression

YoussefBelloum — Fri, 27 Jul 2018 09:12:15 GMT

May bad, I was thinking about dimension selection ignorance when writing exclude chart dimensions.. it is clearer now

Re: please correct this sum expression

pintucs20 — Sat, 28 Jul 2018 07:01:09 GMT

Hi Tiwary,

Please try below mentioned

sum([Patient count]) / sum(TOTAL<Gender,Status> [Patient count])

Regards

Pintu Pandey