topic How to pick Minimum date in QlikView

How to pick Minimum date

kunkumnaveen — Wed, 07 Jul 2021 12:40:49 GMT

Hello All,

I need a help in writing a set analysis expression for one of my requirement

Requirement :

I need to show start of month date and Value in a kpi's for the selected date

Below is a sample data set ,

So basically when ever the application opens by default max date get selected in the above example (30/06/2021)Now in the above left KPi I need to show date as 05/06/2021 and Values as 4000

lets say if i select 29/05/2021 then in it should show 10/05/2021 and value as 1000

I mean to say that min values should be picked from the selected

Please suggest me how to achieve the above requirement

thanks

Re: How to pick Minimum date

Kushal_Chawda — Wed, 07 Jul 2021 14:36:04 GMT

@kunkumnaveen Assuming that your Date filed is in proper Date format, you can write below expression

=sum({<Date>}if(Date = min(total {<Date={">=$(=monthstart(max(Date)))<=$(=max(Date))"}>}Date), Value))

Re: How to pick Minimum date

kunkumnaveen — Thu, 08 Jul 2021 06:20:37 GMT

Thank you it working ,

but could you plz explain me what exactly the below highlighted part bringing

if(Date = min(total {<Date={">=$(=monthstart(max(Date)))<=$(=max(Date))"}>}Date)