topic Re: Unexpected Result from an Expression in QlikView

Unexpected Result from an Expression

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

Hi,

I am trying to calculate the percentage for a Dimension (M/F). When the Gender Dimension is selected in the Filter the result from the calculation is wrong (weird). Obviously my expression is wrong.

= Count({$< Gender = {"M"}>} SalesOrderNumber)/ Count( SalesOrderNumber)

When the Female Gender is selected the % Male calculation is expected to be zero. That is what I am expecting.

How to get that?

Attaching the file.

Thanks

Re: Unexpected Result from an Expression

dplr-rn — Mon, 08 Oct 2018 21:10:06 GMT

ignore the Gender dimension in the denominator. if you dont you are dividing male count/female count

Count({$< Gender = {'M'}>} SalesOrderNumber)/ Count( {$< Gender = >} SalesOrderNumber)

Count({$< Gender = {'F'}>} SalesOrderNumber)/ Count( {$< Gender = >} SalesOrderNumber)

Re: Unexpected Result from an Expression

sqlpuzzle — Tue, 09 Oct 2018 12:21:37 GMT

Why the filter is not getting rid of the filtered dimension?

If I select M in the filter, I was thinking the Female records will be filtered out and the percentage will either dissappear or become zero.

Re: Unexpected Result from an Expression

dplr-rn — Tue, 09 Oct 2018 12:39:03 GMT

With old or new?. New one I shared ignored gender selection for the denominator

Re: Unexpected Result from an Expression

sunny_talwar — Tue, 09 Oct 2018 12:46:10 GMT

May be you need these expressions

= Count({$< Gender *= {"M"}>} SalesOrderNumber)/ Count({<Gender>}SalesOrderNumber)

= Count({$< Gender *= {"F"}>} SalesOrderNumber)/ Count({<Gender>}SalesOrderNumber)

Re: Unexpected Result from an Expression

Jesh19 — Tue, 09 Oct 2018 13:02:01 GMT

You can try something like this:

= Count({$< Gender = {"M"}>} SalesOrderNumber)/ Count(TOTAL SalesOrderNumber)

= Count({$< Gender = {"F"}>} SalesOrderNumber)/ Count(TOTAL SalesOrderNumber)