topic Bar Chart Count Minimum Value in QlikView

Bar Chart Count Minimum Value

LawrSam12 — Sat, 16 Nov 2024 20:52:21 GMT

Hello,

I am trying to build a bar chart counting the number of orders at each stage in the process, these stages are numerical.

My problem is that each order can have multiple stages within it, and I want to report on the earliest (smallest number) of those stages.

For example, I want to be able to have the minimum task stage as depicted below as a dimension in a bar chart.

I've tried using min(total<[Order Reference]>[Stage])

But that displays an Invalid Dimension error.

is there a solution to this?

Thank you

sunny_talwar — Tue, 14 May 2019 15:24:53 GMT

May be you need this

Aggr(Min(Stage), [Order Reference])

LawrSam12 — Tue, 14 May 2019 15:40:36 GMT

Thank you for this - I don't get an error anymore, but it is returning all values as null.

sergio0592 — Tue, 14 May 2019 15:45:17 GMT

Hi,

In your chart, try as calculated dimension

aggr(min(TOTAL <Order> Minimum_Task_Stage),Order,Stage)

sunny_talwar — Tue, 14 May 2019 15:48:19 GMT

What all dimensions do you have in your chart? Do you have any expressions?

LawrSam12 — Thu, 16 May 2019 08:42:10 GMT

thank you both so much for your help.

The expression which worked was:

aggr(min(TOTAL <[Order Reference]> [Stage]),[Order Reference],[Stage])