QlikView | Expressions | AGGR Function with Max and FirstSortedValue function

QlikView | Expressions | AGGR Function with Max and FirstSortedValue function

Abhishek Agarrwal

10 лет назад

61,888 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

ミカサ
ミカサ - 14.04.2022 18:35

Thanks for this video.

Ответить
Danielle
Danielle - 26.08.2021 06:55

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!

Ответить
Laurent Berrebi
Laurent Berrebi - 09.08.2021 10:50

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 ??

Ответить
Anil Kumar Rai
Anil Kumar Rai - 20.04.2020 09:43

Thanks for another good explanation.,,

Ответить
Prince One
Prince One - 02.02.2019 08:24

How do we get your dataset to follow along?

Ответить
Arnaud Chazoule
Arnaud Chazoule - 08.07.2018 18:08

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

Ответить
Akshay Khiste
Akshay Khiste - 29.06.2018 06:10

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.

Ответить
sandeep gupta
sandeep gupta - 16.05.2018 16:15

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

Ответить
Khanyisan Chiya
Khanyisan Chiya - 21.11.2017 23:30

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

Ответить
Don Saluga
Don Saluga - 21.07.2016 16:52

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

Ответить
Albert
Albert - 12.02.2016 18:27

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

Ответить
Venu Gopal Kancharla
Venu Gopal Kancharla - 27.11.2015 11:05

Very good scenario.

Ответить
Fabien Götz
Fabien Götz - 04.09.2015 10:52

Thanks for that great explanation for the AGGR()!

Ответить