QlikView | Expressions | AGGR Function with Max and FirstSortedValue function

Поділитися
Вставка
  • Опубліковано 12 гру 2024

КОМЕНТАРІ • 14

  • @decenator1
    @decenator1 9 років тому +2

    Thanks for that great explanation for the AGGR()!

  • @donsaluga5062
    @donsaluga5062 8 років тому +2

    Thanks for another good explanation. Keep up the good work!

  • @arnaudchazoule7415
    @arnaudchazoule7415 6 років тому

    Thank you for what you have done. Very useful. It's helps a lot.

  • @anilkumarrai6913
    @anilkumarrai6913 4 роки тому

    Thanks for another good explanation.,,

  • @ミカサ-h3z
    @ミカサ-h3z 2 роки тому

    Thanks for this video.

  • @lberrebi
    @lberrebi 3 роки тому

    Excellent video, question the column "order total", for the same customer Name, the 1st line have the information, and no information on the row below for the same customer. How can i put this sum , not on the 1st row, but the last row (for the same customer) ? thk yu
    To be clear:
    for Company AA, "order total" = 1705, is on the row of the min order date (15/1/2006),
    how to show this 1705, in the row of the max, ie in the line 22/4/2006 ??

  • @Ahoto_papa_bi
    @Ahoto_papa_bi 5 років тому

    How do we get your dataset to follow along?

  • @danielle3156
    @danielle3156 3 роки тому

    Hi! I'm trying to use your Agg formula in Qlik Sense and there's an error message that says Agg takes at least two parameters. Could you share an alternative formula that would resolve this error message? Thanks!

  • @akshaykhiste9104
    @akshaykhiste9104 6 років тому

    This will be more useful when we have chart and table box ... Where chart shows count or sum of records of table ... As table gives unique records.

  • @sandeepgupta5131
    @sandeepgupta5131 6 років тому

    can you please tell me in ordertotal ,the value 13810 is same or it is 1381.0 because if 13810 is correct then this value would be greater

  • @venukurs
    @venukurs 9 років тому

    Very good scenario.

  • @lilfleck87
    @lilfleck87 8 років тому

    Couldn't you have just put in Customer Name as the expression instead of doing the first sorted value? What would it have shown?

    • @AbhishekAgarrwal
      @AbhishekAgarrwal  8 років тому +1

      +Albert That will not give the desired outcome as needed in this scenario. I suggest you do a quick experiment based on this data and scenario and without firstsortedvalue and see what it gives and why.

  • @khanyisanchiya53
    @khanyisanchiya53 7 років тому

    hi there, i have been watching your videos and found them helpful however i would like to have a question for you privately with regards to cross tables. please if i may have your email address