topic Re: Minimum possible value in Dimension in QlikView

Minimum possible value in Dimension

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

Hello guys,

I need to get the minimun value in a set of (selectable) date, so that I can check if a date in a record is less or greather than it and print the record or not in a pivot table.

I've tried to set a calculate dimension as "If GanttDate>=Min(DeliveryDate), OrderNumber, Null())" and check the relative flag "Suppress When Value is Null", but this issue doesn't work (I get an Error in Calculate Dimension).

Could anybody help me in this trouble, pls?

Re: Minimum possible value in Dimension

jwjackso — Sat, 29 Aug 2020 22:51:48 GMT

Try adding the Aggr function around your IF statement.

Aggr(If (GanttDate>=Min(DeliveryDate), OrderNumber, Null()),GanttDate)

Re: Minimum possible value in Dimension

NickP_DF — Sun, 30 Aug 2020 08:19:33 GMT

Hello,

thank you for the replay: I'm sorry but your suggestion doesn't work 😞

Since the statement "If GanttDate>=Today(), OrderNumber, Null())" works properly, I thought that a fixed value is necessary instead of a row-by-row calculated one, so a possible workaround should be to get the minimum possible value of the Delivery date by extracting it from the selection parameters, but unfortunately the GetPossibleCount(DeliveryDate) exists and the GetPossibleValue(DeliveryDate) does not.

Do you thing it should be a possible way to explore?

Thanks.

Re: Minimum possible value in Dimension

Kushal_Chawda — Sun, 30 Aug 2020 19:02:24 GMT

try below

Aggr(If (GanttDate>=Min(DeliveryDate), OrderNumber, Null()),GanttDate,OrderNumber)

Aggr(If (GanttDate>=Min(DeliveryDate), OrderNumber, Null()),OrderNumber)

Re: Minimum possible value in Dimension

NickP_DF — Sat, 05 Sep 2020 14:23:04 GMT

The first one works very well!

Thank you so much!