topic Re: Name having max value in table using Set Analysis in QlikView

Name having max value in table using Set Analysis

300sss300 — Wed, 25 Nov 2020 16:16:04 GMT

I am trying the following set analysis to get the name of branch with highest sale but its not working

Max({<Year={'2019'},Month={'Feb'},Day={'28'}>} B_N)

It only gives numerical value if we use

Max({<Year={'2019'},Month={'Feb'},Day={'28'}>} Sales)

Date Fields:

Date B_N Sales

Sergey_Shuklin — Thu, 20 Jun 2019 05:44:31 GMT

Hello!

There is no any clue if B_N contains uniq values or not, so you can use any of this methods:

For uniq values

For non-uniq values

In the attached file values are different beacuse I've reloaded it.