topic Re: Set analysis Excluding calculated value greater than X in QlikView

Set analysis Excluding calculated value greater than X

Wed, 25 Jul 2012 19:50:13 GMT

Hi, I have created monthly bar graph that executes a per unit equation (shown below). I need the graph to exclude any out of range values for the outcome of the equation, such as if the per unit cost is >$10, then that month's per unit cost would be excluded from the graph. As you can see, there is already one set analysis in this equation...

=Sum ( {<CalendarField =>} [Total]) / Sum ( {CalendarField =>} [Volume])

To put it simply, what I need to show is if (total/volume)> 10, exclude from the graph.

Please help.

Re: Set analysis Excluding calculated value greater than X

MayilVahanan — Wed, 25 Jul 2012 19:58:06 GMT

HI,

You can use like this,

If(Sum ( {<CalendarField =>} [Total]) / Sum ( {CalendarField =>} [Volume]) > 0,

Sum ( {<CalendarField =>} [Total]) / Sum ( {CalendarField =>} [Volume]))

If(Sum ( [Total]) / Sum ([Volume]) > 0,

Sum ( {<CalendarField =>} [Total]) / Sum ( {CalendarField =>} [Volume]))

Hope it helps

Re: Set analysis Excluding calculated value greater than X

Thu, 26 Jul 2012 16:41:12 GMT

Thank you! The first expression worked.