Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
LawrSam12
New Contributor

Bar Chart Count Minimum Value

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.

Order ReferenceStageMinimum Task Stage
ABCD32
ABCD22
ABCD62
EFGH11
EFGH91
EFGH41

 

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

But that displays an Invalid Dimension error.

is there a solution to this?

Thank you

1 Solution

Accepted Solutions
sergio0592
Valued Contributor II

Re: Bar Chart Count Minimum Value

Hi,

In your chart, try as calculated dimension

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

 

5 Replies

Re: Bar Chart Count Minimum Value

May be you need this

Aggr(Min(Stage), [Order Reference])
LawrSam12
New Contributor

Re: Bar Chart Count Minimum Value

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

sergio0592
Valued Contributor II

Re: Bar Chart Count Minimum Value

Hi,

In your chart, try as calculated dimension

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

 

Re: Bar Chart Count Minimum Value

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

LawrSam12
New Contributor

Re: Bar Chart Count Minimum Value

thank you both so much for your help.

The expression which worked was:

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