topic Re: min(Value) in QlikView

min(Value)

Frank_Hartmann — Wed, 15 Apr 2015 07:11:02 GMT

Hi QV Community,

i have the following table:

Now i would like create a diagramm with "Date" as dimension and only showing the minimum Value of Metric for the corresponding month.

For example:

2015-01 ---> 3 and 1, so datapoint should be 4

2015-02 ---> 2 and 5, so datapoint should be 7

2015-03 ---> 3 and 0, so datapoint should be 3

Has anybody the clue how to construct the formula??

thx in advance for helping

swuehl — Wed, 15 Apr 2015 07:21:14 GMT

1) Use Date as Dimension

2) as Expression:

=sum( aggr( min( Value), Date,Metric))

Frank_Hartmann — Wed, 15 Apr 2015 07:23:57 GMT

Thank you

Frank_Hartmann — Wed, 15 Apr 2015 07:39:56 GMT

One more question:

to get to the above table i had to set some filters.

so the sum(aggr(min( Value), Date,Metric)) is only working for the original table without setting the filters:

But i need to set one filter for "Usecaserelevance=1"

I tried like:

sum(aggr(min(sum({$<UseCaseRelevance={'1'}>}Value)), Date,Metric))

but this is not working

Any ideas?

MayilVahanan — Wed, 15 Apr 2015 08:01:52 GMT

Try like this

sum(({<UseCaseRelevance={'1'}>}aggr(min({<UseCaseRelevance={'1'}>}Value), Date,Metric))