Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
microwin88x
Contributor III

Max value for Date with Set Analysis

Hello,

I have the following table:

- Dimensions: Op_Date / Reference

- Expression: Amount = Sum(Amount)

(Note that Op_Date format is DD/MM/YYYY)

Op_DateAmountReference
13/2/2018--
14/2/2018200AB1
14/2/2018300AD3
14/2/2018400CX5
15/2/2018250RT3
15/2/2018350TP7
16/2/2018--

What I need is to see the table (modifying my Expression) for the Max Op_Date with Reference <> Null.

So if I select 15/2/2018, I'd see:

Op_DateAmountReference
15/2/2018250RT3
15/2/2018350TP7

And if I select 16/2/2018, I'd see also (because Reference is Null for that date):

Op_DateAmountReference
15/2/2018250RT3
15/2/2018350TP7

Do you know how could I do that?

Thank you!!!

1 Solution

Accepted Solutions
Highlighted

Re: Max value for Date with Set Analysis

May be this

Sum({<Op_Date = {"$(=Date(Max({<Op_Date = {[$(='<=' & Date(Max(Op_Date), 'DD/MM/YYYY'))]}, Amount = {

  • }>}Op_Date), 'DD/MM/YYYY'))"}>}Amount)
  • View solution in original post

    4 Replies
    Highlighted

    Re: Max value for Date with Set Analysis

    May be this

    Sum({<Op_Date = {"$(=Date(Max({<Op_Date = {[$(='<=' & Date(Max(Op_Date), 'DD/MM/YYYY'))]}, Amount = {

  • }>}Op_Date), 'DD/MM/YYYY'))"}>}Amount)
  • View solution in original post

    Highlighted
    vishsaggi
    Esteemed Contributor III

    Re: Max value for Date with Set Analysis

    Hi Sunny, i have been seeing few of your set analysis expressions you are using [] square brackets does that mean you are doing a search?

    Highlighted

    Re: Max value for Date with Set Analysis

    Yes, a search string using [], instead of double quote within double quote

    Highlighted
    vishsaggi
    Esteemed Contributor III

    Re: Max value for Date with Set Analysis

    Thanks. Got it. Never used that way.