Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Get min and max possible value in specific field based on current selections

Hi,

I was wondering if it is possible to get the minimum and the maximum possible value in a specific field (in which no selections have been made), based on applied filters on other fields.

Attached an example. The goal is to obtain the value 2014/03/01 for min and 2014/10/01 for max.

I tried with FieldValue, but that did not work as expected.

e.g. ='Lowest possible date value: '  &min(FieldValue(Date,1))

example.png

All suggestions are welcome!

Regards,

Maarten

1 Solution

Accepted Solutions
sebastianlettner
Contributor

Re: Get min and max possible value in specific field based on current selections

Hi,

the problem was, that Date was not a Date value.

Take a look an the script. Now Date is a Dual value so you can use the Max/Min function

4 Replies
sebastianlettner
Contributor

Re: Get min and max possible value in specific field based on current selections

Hi,

the problem was, that Date was not a Date value.

Take a look an the script. Now Date is a Dual value so you can use the Max/Min function

awhitfield
Esteemed Contributor

Re: Get min and max possible value in specific field based on current selections

Hi Maarten,

see attached version using a "real Calendar", works as expected with min and max

Regards

Andy

Not applicable

Re: Get min and max possible value in specific field based on current selections

Dear Sebastian,

Dear Andrew,

Thanks a lot! Didn't guess it was that simple... but seems indeed to solve the problem.

At a certain point one is no longer taking a look at the basics... . Luckily your focus was still very sharp

Have a nice day!

Maarten

awhitfield
Esteemed Contributor

Re: Get min and max possible value in specific field based on current selections

No Problem,

it's very easy to make things too complicated and miss the obvious !

You have a good day too!

Regards

Andy

Community Browser