topic Re: Calculate measure issue in QlikView

Calculated measure issue

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

Hi,

I'm try to get below output using below expression and got null value for one condition can you advise me

aggr(count([Opening SOH]),ArticleNo,Color)/aggr( count(total [Opening SOH]),ArticleNo,Color)

sunny_talwar — Mon, 16 Oct 2017 16:51:47 GMT

What is your dimension? It seems to be a calculated dimension and I am not sure what that is?

sunny_talwar — Mon, 16 Oct 2017 16:55:45 GMT

Try this

Dimension

=Aggr(If(Count([Opening SOH])/Count(TOTAL [Opening SOH]) < 0.25, '< 4 Sizes', '>4 Sizes'), ArticleNo, Color)

Expression

Count([Opening SOH])/Count(TOTAL [Opening SOH])